Call us today: 0800 028 3045

VBA in Excel Course Part 3 – Application Integration

Is it right for me?

Our VBA in Excel Part 3 course is aimed at those who are already creating VBA code and need to learn more about how to pass information between the different applications and create integrated solutions.

You must have either attended the VBA in Excel –Part 1 course or have equivalent knowledge.

What will I get out of it?

By the end of the course you will be able to:

  • Connect to other applications
  • Use the other application’s' Object Models
  • Pass data to and from Word, PowerPoint, Outlook and Access

Versions available

2003, 2007, 2010

Related courses in our range

What does it cover?

Working with other applications

  • Using each package'’s application object
  • Sending emails
  • Transferring whole spreadsheets to Access
  • Importing text files

Sharing data with other applications

  • Early binding vs late binding
  • Setting references to other applications
  • Creating application variables
  • Setting application variables

Sharing data with Word

  • Interacting with Word
  • The Word Object Model
  • Word VBA commands
  • Sending Excel data to Word
  • Opening Word documents from Excel

Sharing data with Access

  • Interacting with Access
  • The Access Object Model
  • Access VBA commands
  • Working with recordsets
  • Using queries
  • Working with querydefs
  • Transferring data between Excel and Access

Sharing data with PowerPoint

  • Interacting with PowerPoint
  • The PowerPoint Object Model
  • PowerPoint VBA commands
  • Sending Excel data to PowerPoint
  • Opening PowerPoint presentations from Excel

Sharing data with Outlook

  • Interacting with Outlook
  • The Outlook Object Model
  • Outlook VBA commands
  • Sending mail to Excel recipients

“This is not the first course I attended at Thales Training & Consultancy and as before the trainer was excellent. Concepts were thoroughly explained and all questions were answered.”

Adam Hallgarth, Acturial Analyst, Sun Life Finance of Canada

Course Summary

  • Duration: 1 day
  • Price: £700.00+VAT
  • Location: As required
  • Select date: In company only for 4 or more delegates
Call 0800 028 3045 to book

Send to a colleague

Please enter details below and click 'submit'

Tailor this course

If you are interested in this course but would like it tailored to your specific needs, contact Karen Osborn on 0800 028 3045.

Alternatively, enter your details below and one of our team will contact you.


Thales Training & Consultancy is a highly successful training services company based in Crawley. We help companies to develop advantage through learning and development. Highly trusted by leading enterprises, we deliver a full range of dedicated training solutions that enable organisations to achieve key business goals. The 4 core services we offer are Training Courses, Supply Management, Bespoke Services and Managed Services. Our successful partnerships with clients prove that the delivery and management of the right training and development can significantly enhance the pursuit of business excellence.


Thales Training & Consultancy. Registered in England and Wales. Registered Office: Sackville House, Northwood Park, Gatwick Road, Crawley, West Sussex RH10 9XN. Registered in England Number: 1597499. Thales Training serve the local area of Crawley, Gatwick, West Sussex, Surrey and Kent as well as offering training courses at locations around the UK