Excel VBA Programmierung Aufbau - Microsoft Office Training

Beschreibung

Seminar content
Protecting modules, working with certificates
Passing on procedures with add-ins
Extended data types - arrays, compounds, enumeration variables
One-dimensional and multidimensional arrays
Using dynamic and static arrays
Validity ranges of variables, variable passing byVal and byRef
Using object variables, referencing objects
Range object, chart object, pivot table object
Deepening: events, for-each, user-defined functions
Programming in the area of folders/files
Create ASCII or CSV files
Access to integrated Excel dialogs and office dialogs
Deepening: Create own dialog forms
Create your own error messages
Accessing other Office applications

Translated with www.DeepL.com/Translator (free version)

Ziel

/

Anforderungen an die Teilnehmer

VBA programming Microsoft Office Excel basic seminar or comparable knowledge

Teilnehmer

Microsoft Office Excel user