Excel VBA AdvancedSTL
Excel VBA Advanced
Courses never cancelled. Restaurant lunch. Last minute rescheduling. 24 month delegate support forum. And more... 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.
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 detail
The versatile CurrentRegion object
Working with collections of Workbooks and Worksheets
Manipulating Charts through VBA
Manipulating PivotTables through VBA
Efficient variable storage with arrays
The Array function
Triggers and Events
Running macros automatically
Executing macros on a timer
Associating macros with other Workbook events
Passing parameters by reference and by value
Working with Text Files
Importing text files
Exporting text files
Using the FileStream object
Linking with Office
Connecting to other Office applications
Working with other Office applications
Linking to data sources using ADO
Understanding ActiveX Data Objects
Using Excel to communicate with other data sources
Understanding the connection string
Adding, reading, modifying and deleting data
How macro security works
Password protecting your code
Distributing macros via an Add-In
Appendix: Classes and Objects
Working with Class Modules
List price £699 per delegate. Promotional rates apply: see event listings for current prices. On-site training also available: Contact us.
Be Inspired! Watch the Video
STL - Helping businesses deliver productivity and efficiency gains
Learning solutions from leadership and management training programmes to business intelligence and applications training. London based with a global reach....
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.
Contact information for STL
Reviews by course attendees
Average rating 4.5Based on 406 reviews
Find out more about this Excel VBA Advanced course - simply fill out your details:
Are you curious about the L&D strategies of some of the U.K.'s top companies?
Find out what they're up to in findcourses.co.uk's second annual U.K. L&D Report!