Excel VBA Level 4

Progressive Training & Development

Course

In Southwark

Price on request

The best Excel courses

See all

See all

Description

  • Type

    Course

  • Location

    Southwark

  • Duration

    1 Day

Anyone wishing to automate common worksheet operations, convert worksheets into forms and understand Excel VBA code.

Important information

Government funding available

Facilities

Location

Start date

Southwark (London)
See map
202 Blackfriars Road, SE1 8NJ

Start date

On request

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

See related categories

Excel VBA Level 4

Price on request

The best Excel courses

See all

See all