vba courses london - Coding Excel VBA from within Access

The UK's most regular instructor-led training courses.
Training information: vba courses london · Excel london

Resolved · Low Priority · Version Standard

Coding Excel VBA from within Access

Arthur has attended:
Access VBA course
Excel VBA course

by - delegate Arthur [2 posts] (2007 Jan 19 Fri, 16:41) Reply

Are there many limitations in using Access as an automation server for controlling the output and format of excel spreadsheets which use data contained in an Access Database ?

RE: Coding Excel VBA from within Access

by - trainer Carlos gold contributer [479 posts] (2007 Jan 26 Fri, 11:56) Reply

Not too many limitations. Access and Excel allow for the most benefit from integration among Office applications.

Exporting data to Excel and then manipulating it from Access is easily done.

RE: Coding Excel VBA from within Access

by - delegate Arthur [2 posts] (2007 Jan 29 Mon, 02:41) Reply

Thanks Carlos !
I start my new job tomorrow morning and look forward to putting what I learned on the courses to good use!
Please watch this space for more questions!
Best regards...Arthur

· Introduction to Visual Basic for Applications
· What Is Microsoft Excel VBA and How Can It Help You Work Smarter?
· Should You Send Managers To VBA Training?
· How To Find A Good VB For Access Trainer
· Visual Basic Returns To The Macintosh

Vba tip:

Stop Display Alerts In Excel

When creating or deleting a Worksheet in Excel you don't want Excel to inform you "A file already exists....." Or "Do you want to save this file...".

To stop these alerts happening use the following line of code:

Application.DisplayAlerts = False

After the Create or Delete routine use:

Application.DisplayAlerts = True

View all VBA hints and tips

Rate this page: