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

• Excel Macros Specialist
• VBA in Excel Part 1
• VBA in Excel Part 2 - Spreadsheet Developer
• Excel Business Intelligence and Dashboards

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