Categories:
Visual Basic Training
£755 per delegate. This may be less for special offers on specific course dates and in-company training courses
Duration: 2 days
Trainer: S047OW
Need course dates or locations to suit you? CLICK HERE TO SEND ENQUIRY...
Introduction
Course Contents
Revision of VBA
- Referencing other applications
- Instantiating objects
- Writing inter-application code
- Referencing FileSystemObjects
- Working with files and folders
- Untyped collections
- Creating typed collections
- Creating event sinks
Linking to data*
- ADO or Access Database Engine
- Referencing the right library
- Opening and using recordsets
Arrays
- Creating and populating arrays
- Dynamic arrays
- The PRESERVE keyword
- ByRef and ByVal
- Using optional arguments
- Using ParamArray
If you already know how to create subroutines in VBA, are happy declaring variables and can write loops and conditions without a qualm, this is the course for you! Assuming a good working knowledge of Visual Basic for Applications, the course shows you how to loop over collections, reference other applications, work with files in all of their manifestations, create your own classes (!) and much more. The course uses examples drawn from Excel, Access, Word and Outlook.
Course Contents
Revision of VBA
- Objects and collections
- Methods and properties
- Looping over collections
- Using object variables
Links to other applications
- Methods and properties
- Looping over collections
- Using object variables
Links to other applications
- Referencing other applications
- Instantiating objects
- Writing inter-application code
FileSystemObjects
- Referencing FileSystemObjects
- Working with files and folders
FileDialogs
- Using FileDialogs
- Allowing multiple selection
- Allowing multiple selection
Working with text files
- Avoiding using INPUT/OUTPUT
- Reading and writing text files
- Reading and writing text files
Class modules
- What is a class?
- Designing classes
- Creating properties and methods
- Consuming classes
Advanced class modules topics
- Designing classes
- Creating properties and methods
- Consuming classes
Advanced class modules topics
- Untyped collections
- Creating typed collections
- Creating event sinks
Linking to data*
- ADO or Access Database Engine
- Referencing the right library
- Opening and using recordsets
Arrays
- Creating and populating arrays
- Dynamic arrays
- The PRESERVE keyword
Passing arguments
- ByRef and ByVal
- Using optional arguments
- Using ParamArray
Advanced programming ideas*
- Using functions in code
- Recursive programming
- Enumerations
- Recursive programming
- Enumerations
Working with shapes*
- Adding shapes
- Positioning shapes
- Formatting shapes
- Positioning shapes
- Formatting shapes
Please note that any items marked with a * will be covered if time allows.
Course Times
Usually 9.30am - 4.30pm. Course times will be confirmed in the Joining Instructions once the course has been booked.
The course either has new dates in data loading, or is only run as a dedicated or In Company course.
Telephone Hotline
01933 233884
(Monday to Friday - 8:00am to 5:30pm).
© 2021 Book My Course Limited. All rights reserved
Home | About Us | Contact Us | FAQs | Privacy Policy | Terms & Conditions | Site Map | News / Articles | Cookie Policy