Duration: 2 days (13 hours)
Cost: £670 +VAT per person (prices vary for bespoke courses – please enquire)
This course is aimed at experienced VBA users or those who have attended our Part 1 course and have started to use the language.
Part 2 expands on the huge array of commands and elements of the data model that can be used and looks at building more complex VBA models
By the end of the course you will be able to:
- Use comparison operators and system functions
- Use Arrays
- Work with ranges
- Work with the worksheets and workbooks collections and objects
- Use application objects
- Use the FileSystemObject
- Create function procedures
- Import and save text files
- Connect to other applications
Cost: £670 +VAT per person
Click here to view next available dates and complete booking request.
Please email firstname.lastname@example.org if you would like to discuss the course before booking or to discuss bespoke programme options.
I would recommend the course, there was a lot of content covered and Susan was very happy to focus in on keys areas of the course as we required. Priorities and areas of focussed considered for all delegates. Content put in to practise on live examples. Susan was more than happy to work on some challenges directly with us there and then. Susan is clearly very knowledgable and happy to support with all queries. Together we were able to work through some challenges in order to resolve. Susan also allows you to try things out and approach things in different ways but ensuring you are kept on track and thins are kept neat and tidy!
I would recommend the course to others. Susan is very knowledgeable and has a great ability to provide simple explanations to potentially complex queries. The Beehive venue is very nice and I found the course administration to be very simple and straightforward.