Excel VBA Level 4
Course
Inhouse
Description
-
Type
Course
-
Methodology
Inhouse
-
Duration
1 Day
Anyone wishing to automate common worksheet operations, convert worksheets into forms and understand Excel VBA code.
Important information
Government funding available
About this course
Must be confident or at least have
had sufficient exposure to the concepts covered in Levels 1-3.
Reviews
Course programme
Anyone wishing to automate common worksheet operations, convert worksheets into forms and understand Excel VBA code.
PREREQUISITES
Must be confident or at least have had sufficient exposure to the concepts covered in Levels 1-3.
Revision of Level 3
Creating Add-Ins (mini Excel applications)
-
What? Why?
-
The Add-ins dialog box
-
Adding descriptive information
-
Creating
-
Opening
-
Distributing
-
Modifying
-
Creating, Deleting, Renaming folders
-
Copying / Moving / Renaming files
-
Getting a list of all files in a folder
-
Arrays
-
Declaring and using redim
-
Multidimensional arrays
-
Dynamic Arrays
-
Using an Array
-
Declaring and using redim
-
ADO Recordsets
-
Creating
-
Filtering
-
Sorting
-
Adding new records to
-
Counting records
-
Pasting into a sheet
-
Creating
-
Setting References
-
Starting another application
-
Activating the application
-
Outlook
-
Sending an email through Outlook
-
Sending separate emails per region
-
Sending an email through Outlook
-
Word
-
Creating a memo with a chart
-
Creating a memo with a chart
-
Access
-
Attaching to a database and appending the spreadsheet data
-
Attaching to a database and appending the spreadsheet data
Excel VBA Level 4