Excel VBA Level 4
Sponsored links
Must be confident or at least have had sufficient exposure to the concepts covered in Levels 1-3.
Anyone wishing to automate common worksheet operations, convert worksheets into forms and understand Excel VBA code.
| Delivery: |
|
| Regions: |
|
| Category: |
Further Details
Revision of Level 3
Creating Add-Ins (mini Excel applications)
· What? Why?
· The Add-ins dialog box
· Adding descriptive information
· Creating
· Opening
· Distributing
· Modifying
Manipulating Windows Explorer
· Creating, Deleting, Renaming folders
· Copying / Moving / Renaming files
· Getting a list of all files in a folder
Absorbing lists of data to be use elsewhere
· Arrays
Declaring and using redim
Multidimensional arrays
Dynamic Arrays
Using an Array
· ADO Recordsets
Creating
Filtering
Sorting
Adding new records to
Counting records
Pasting into a sheet
Intro to Integrating with other Office Applications
· Setting References
· Starting another application
· Activating the application
· Outlook
Sending an email through Outlook
Sending separate emails per region
· Word
Creating a memo with a chart
· Access
Attaching to a database and appending the spreadsheet data
Codesigning your vba
This Training Course is taught in classrooms in the following locations:
London SE
Information provided is for information purposes only and no guarantees are made with regards to accuracy. It is advised that all details are checked prior to making a booking. Contents © 1999 - 2012. All rights reserved.
