Excel VBA Advanced
- Upon completion of the course delegates will have a good understanding of the major components of VBA.
- Delegates will expand their reach by being able to use VBA to communicate with other Office applications, such as Word.
- In addition, the course also covers working with data from database applications such as Access, and manipulating and presenting the data.
What to expect
- Courses never cancelled .
- Restaurant lunch .
- Last minute rescheduling .
- 24 month delegate support forum .
- And more... .
Upcoming start dates
Choose between 46 start dates
Upcoming start dates
Suitability - Who should attend?
This course is aimed at individuals with a basic grounding in Excel VBA and an advanced knowledge of Microsoft Excel, who wish to develop their skills with introduce more sophisticated automation into their workflows.
Training Course Content
The Excel Object Model
Exploring the Range object in detailThe versatile CurrentRegion object
Working with collections of Workbooks and Worksheets
Manipulating Charts through VBA
Manipulating PivotTables through VBA
Arrays
Efficient variable storage with arraysArray optimisation
Dynamic arrays
The Array function
Triggers and Events
Running macros automaticallyExecuting macros on a timer
Associating macros with other Workbook events
Advanced Parameters
Passing parameters by reference and by valueWorking with Text Files
Importing text filesExporting text files
Using the FileStream object
Linking with Office
Connecting to other Office applicationsWorking with other Office applications
Linking to data sources using ADO
Understanding ActiveX Data ObjectsUsing Excel to communicate with other data sources
Understanding the connection string
Adding, reading, modifying and deleting data
Add-Ins
How macro security worksPassword protecting your code
Distributing macros via an Add-In
Appendix: Classes and Objects
Working with Class ModulesExpenses
List price £699, promotional rates available. STL are the only company to offer a dynamic pricing and availability model, updated live on our site, daily on this portal. Closed group training options available (at your offices, UK wide/International or our London Venues). Contact us below.
Request information - obligation free
Customer Outreach Award
We believe that it should be easy for you to find and compare training courses.
Our Customer Outreach Award is presented to trusted providers who are excellent at responding to enquiries, making your search quicker, more efficient and easier, too.
Reviews by course attendees
Average rating 4.6
Based on 492 reviews.
Write a review!
5/5
Helen Corporate Development & Strategy Associate (M&A)
01 Nov 2023
5/5
Matt
04 Jan 2023
n/a
STL
1 Northey Street, 2nd Floor, CA House
E14 8BT London
STL
Helping businesses improve performance with proven learning and development solutions. London-based with a global reach. STL seek to provide an unrivalled value and quality service, enabled by our strong working culture. Our 500+ courses deliver learning solutions across leadership and...
Ads
Thank you Jens; a fantastic course; I really appreciate the tailored approach and helpfulness.