START
 

Advanced VBA

Wise Owl
Course summary
Length: 2 days
Location: Nationwide
Next available date: Enquire for details! - Nationwide

Course Description

Advanced VBA Training Course - Manchester, LondonLearn Advanced VBA with Wise Owl - 2-Day In-House Course in the UK

Skills VBA (Visual Basic for Applications) are a great asset when working intensely with Microsoft Office products. Specifically designed for proficient users, this advanced in-house training course in VBA is designed to take delegates to the highest level of ability in using the VBA language.

Delegates of this course will work through guided activities to learn as master skills spanning looping over collections, referencing other applications, working with files in all of their forms and creating classes.

Suitability - Who should attend?

This advanced VBA course is designed for teams who are familiar with and use VBA on a regular basis. Delegates are expected to be ables to create subroutines, declare variables and write loops and conditions in VBA prior to course attendance. 

Outcome / Qualification etc.

Advanced VBA Training CourseUpon completion of this course, delegates will have an advanced understanding of VBA, including looping over collections, referencing other applications and more. 

Training Course Content

This training course will relate the essentials of advanced VBA, including:

  • Revision of VBA
    • Objects and collections
    • Methods and properties
    • Using object variables
    • Looping over collections
  • Links to other applications
    • Referencing other applications
    • Instantiating objets
    • Writing inter-application code
  • FileSystemObjects
    • Referencing FileSystemObjects
    • Working wit files and folders
  • FileDialogs
    • Using FileDialogs
    • Allowing multiple selection
  • Working with text files
    • Avoiding INPUT / OUTPUT
    • Reading and writing text files
  • Class modules
    • What is a class?
    • Designing classes
    • Creating properties and methods
    • Consuming classes
  • Advanced class modules topics
    • Untyped collections
    • Creating types 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
  • Working with shapes
    • Adding shapes
    • Positioning shapes
    • Formatting shapes

Expenses

This course is available on an in-house basis to groups, teams and companies. Enquire for details!

Provider: Wise Owl

Wise Owl - Specialist Microsoft Training in London, Birmingham, Manchester and more

The Wise Owl team has made a name for itself delivering specialist Microsoft training for software enthusiasts, by software enthusiasts. With a team of five dedicated full-time trainers, Wise Owl have the knowledge, resources and enthusiasm to deliver Microsoft training...


Read more and show all courses with Provider: Wise Owl

Contact information for Wise Owl

Wise Owl


Barlow House
Minshull Street
M1 3DZ Manchester

 Show phone number
www.wiseowl.co.uk

Reviews by course attendees

          (5)
Adam Yates   |   16/01/2016
I would like to say the training was absolutely fantastic, the trainer was brilliant and was able to answer any questions regardless of the context or complexity. The session was intense but well-paced and there was a great deal of flexibility so that it could be tailored to the three of us on the course! I had high expectations but was still su...
Show more
Enter & win £50 voucher

 
Find a course for you!

  Read the course
 summary on this page

 Fill in your details and Request information

 Receive all the info you need

 
Similar courses

With Activia, IT User training comes the way you want it: at your place or ours; off-the-shelf or bespoke; scheduled public classes or closed private courses matched to your requirements.

 
Find more courses here