Excel VBA Level 4
Course Outline

DURATION	1 day
PREREQUISITES	Must be confident or at least have had sufficient exposure to the concepts covered in Levels 1-3.
DESCRIPTION	Anyone wishing to automate common worksheet operations, convert worksheets into forms and understand Excel VBA code.
COURSE DATES	Click here to request an alternate date Or call us on 020 313 73958 from 8:00 to 22:00 Monday to Sunday. Weekday Thu, 23-Sep-10 09:30 - 16:30 £200 Weekend Sat, 25-Sep-10 10:00 - 16:30 £200 Weekday Thu, 14-Oct-10 09:30 - 16:30 £150 Weekend Sat, 16-Oct-10 10:00 - 16:30 £200 Weekday Thu, 4-Nov-10 09:30 - 16:30 £200 Evening Mon, 15-Nov-10 and Tue, 16-Nov-10 18:30 - 21:30 £200 Weekday Mon, 6-Dec-10 09:30 - 16:30 £200 Evening Wed, 22-Dec-10 and Thu, 23-Dec-10 18:30 - 21:30 £200 Weekday Fri, 7-Jan-11 09:30 - 16:30 £200 Evening Mon, 17-Jan-11 and Tue, 18-Jan-11 18:30 - 21:30 £200 Any One-to-One Tuition Any Date - Fully Customisable 09:30 - 16:30 £400 Levels 1-4 Specials: Click here to request an alternate date Or call us on 020 313 73958 from 8:00 to 22:00 Monday to Sunday. Weekday Mon, 11-Oct-10 - Thu, 14-Oct-10 09:30 - 16:30 £540

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