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
Guide price
£150 |
