Last updated
Kurskod
vbaexceladv
Varaktighet
14 timmar (vanligtvis 2 dag inklusive pauser)
Översikt
Kursen avslöjar hemligheterna för effektiv skrivning av avancerade applikationer i VBA applikationen MS Excel .
Efter kursen kan du:
- Skriv en avancerad objektorienterad applikation
- Konvertera textfiler
- Användning av externa datakällor
- Använd externa bibliotek
Kursplan
Excel Object Model
- The protection sheet from VBA
- Object Workbook, Workbooks collection
- Worksheet Object, Collection Worksheets
- Validation sheets
- Practical methods of the Range object
- Copy, paste, paste special
- Property CurrentRegion
- Find, replace
- Sorting ranges
- Charts (Object Chart)
Events
- Application-level events
Boards
- Dynamic arrays
- Table arrays Variant
- Optimizing arrays and memory
- Multi-dimensional arrays
Object-Oriented Programming
- Classes and Objects
- Creating classes
- Creating and Destroying Objects
- Create methods
- Create property
- Validation data using property
- The default properties and methods
- Error handling in the class module
Create and manage collections
- Create a collection
- Adding and removing items
- References to the components (using a key and an index)
Advanced structures and functions VBA
- Passing parameters by value and reference (ByRef and ByVal)
- Procedures with a variable number of parameters
- Optional Parameters and Defaults
- Procedures of unknown number of parameters (ParamArray)
- Enumeration, convenient parameter passing
- Type the user (User-defined Type)
- Service Null, Nothing, empty string "", Empty, 0
- Type conversion (Conversion)
File Operations
- Opening and closing text files
- Reading and writing text and binary data
- Processing of records in the CSV file
- Efficient processing of text files
Use VBA functions in other applications
Extras
- Create your own add-ons
- Create a toolbar for addition
- Installing your own add-ons and their protection
Using external libraries
Connecting to external databases (ODBC, OLEDB)
Vittnesmål
We also do Consultancy!
We work with leading clients across a wide range of technologies!
Reach out for Project | Staff Enhancement | System Audit Consulting