Course

Inhouse

Price on request

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.

Questions & Answers

Add your question

Our advisors and other users will be able to reply to you

Who would you like to address this question to?

Fill in your details to get a reply

We will only publish your name and question

Reviews

Course programme

DESCRIPTION
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

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

Excel VBA Level 4

Price on request