START
 

Advanced VBA

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

Advanced VBA

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

Request information - obligation free

Fill out your details to find out more about Advanced VBA.

  Contact the provider

  Get more information

  Register your interest

Errors
Optional
Optional
Optional

Contact information for Wise Owl

Wise Owl


Barlow House
Minshull Street
M1 3DZ Manchester

 Show phone number
www.wiseowl.co.uk

Contact Wise Owl

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
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

 
Request information

Find out more about this Advanced VBA course - simply fill out your details:

 
Find more courses here

 
Have your say:

apprenticeships