EXCEL VBA PROGRAMMING AND ITS APPLICATIONS IN CHEMICAL ENGINEERING

Diplomsko delo obravnava osnovne elemente programskega jezika VBA v okviru programa Excel. Cilji diplomskega dela so spoznavanje programiranja v jeziku VBA, kreiranje makrov, definiranje funkcij v kemijsko-tehniških izračunih in prenos informacij med preglednico in okoljem VBA. V diplomski nalogi smo prikazali, da lahko z uporabo VBA rešujemo različne primere na področju kemijske tehnike. Omejili smo se na štiri preprostejše primere: kreiranje makrov, računanje tlaka z enačbami stanja, izračunavanje ničel funkcije in numerično integracijo. Za vsak primer smo prikazali matematični model, narisali diagram poteka, napisali kodo programa in prikazali rezultate. Diplomsko delo je osnova za spoznavanje in uporabo programskega jezika VBA pri študiju kemije in kemijske tehnologije.This diploma thesis deals with basic elements of VBA programming language within Excel environment. The goals of the thesis are: introduction of VBA programming, creation of macros, definitions of functions in chemical and technical calculations as well as the transfer of information between a spreadsheets and VBA environment. The thesis demonstrates how different problems in the field of chemical engineering can be solved by using VBA. The process of solving is presented through four basic cases: creation of macros, calculating a pressure by using equations of state, calculation of functions roots, and numerical integration. Each problem was presented by its mathematical model, a flowchart, a programme code, and the results. This diploma thesis could serve as a basis for learning and using VBA programming language during the studies of Chemistry and Chemical Engineering