Excel VBA Level 5
Course Outline

DURATION 1 Day
PREREQUISITES This course is for Advanced Excel users who have experience in VBA programming within Excel.  You need to have the equivalent knowledge of Access Levels 1 & 2 and Excel VBA Levels 1 & 2.
DESCRIPTION Excel users. Access users. You′re probably among the majority, living in one camp or the other but rarely crossing between the two. Yet Microsoft designed these applications to work together. On this course, you′ll discover how Access benefits from Excel′s flexible presentation layer and versatile analysis capabilities, while Access′s relational database structure and robust querying tools enhance Excel. Once you learn to make the team work, you′ll find that your team′s productivity is the real winner.
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 Fri, 24-Sep-10 09:30 - 16:30 £200
Evening Wed, 29-Sep-10 and Thu, 30-Sep-10 18:30 - 21:30 £200
Weekday Thu, 7-Oct-10 09:30 - 16:30 £200
Evening Mon, 18-Oct-10 and Tue, 19-Oct-10 18:30 - 21:30 £200
Weekday Fri, 5-Nov-10 09:30 - 16:30 £200
Weekend Sat, 20-Nov-10 10:00 - 16:30 £200
Weekday Tue, 7-Dec-10 09:30 - 16:30 £200
Weekend Sat, 25-Dec-10 10:00 - 16:30 £200
Weekday Mon, 10-Jan-11 09:30 - 16:30 £200
Weekend Sat, 22-Jan-11 10:00 - 16:30 £200
Any One-to-One Tuition
Any Date - Fully Customisable		 09:30 - 16:30 £400

 

 

 

Creating Excel Add-Ins

  • What is an Add-In
  • Why Create Add-Ins
  • Working with Add-Ins
  • Add-In Basics
  • An Add-In Example
    • Setting up the workbook
    • Testing the workbook
    • Adding descriptive information
    • Creating the add-in
    • Opening the add-in
    • Distributing the add-in
    • Modifying the add-in

 

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 Used Elsewhere

  • Arrays
    • Declaring and using redim
    • Multidimensional arrays
    • Dynamic Arrays
    • Using an Array
  • ADO Recordsets Introduction
    • Creating unbound Recordsets
    • Filtering
    • Sorting
    • Adding new records to
    • Counting Records
    • Pasting into a sheet

 

Interacting with Other Office Applications

  • Starting Another Application from Excel
  • Getting Word’s Version number
  • Controlling Word from Excel
  • Controlling Excel from Word
  • Sending Personalised emails using Outlook
  • Working with ADO
  • Ten VBA Questions and Answers
  • Some useful Excel Resources

 

Codesigning your VBA

 

 

 

 


Home | Contact | Terms and Conditions