Instruments and Control
VŠB-TU Ostrava, 6.5.2003
| Annotation of paper No. 13 |
|---|
| Title: | Visual Basic for Applications in Ms Office environment |
| Author(s): | ANDRÁSSY, Roland |
| Text: | Program language Visual Basic for Applications is single program language supported by application package Microsoft Office. By the help of VBA is possible to reach many tasks, which are impossible to make through customer environment of Excel or Word. Visual basic for applications make possible to create advanced tools for data examination, to design forms served toward data collection and creating their reports, dynamically to get data from external database, to create report of pivot table by pressing lone key, to note down codes, which dynamically communicate with user through window dialogs and entry fields, temporarily are stored into memory, to respond to event, look like sheet opening or change of entry data on sheet, eventually manage other application, e.g . Word, Access. By helps of this language is possible to automatize work with data processing of great amount entry data. Work, which having been performed for hours, then is completed per several minutes. |