by Paul Kelly | | Copying Data, Vault Video
Webinar Number: W0060 Advanced Filter is an amazing tool for VBA users. It’s advantages include ease of use, speed, simplicity of code as well as extensive filtering options. This is a must have tool in any VBA programmers toolbox. What is Advanced Filter Why...
by Paul Kelly | | Classes and Objects, Vault Video
Webinar Number: W0059 What are objects in Excel VBA and why do you need them? Objects are a vital part of Excel VBA and mastering them is key to becoming a powerful VBA user. The, funny thing is, that most VBA users don’t really understand objects and how to use...
by Paul Kelly | | Copying Data, Databases, Vault Video
Webinar Number: W0058 This webinar includes: Why querying data using standard VBA is problematic. What is ADO and how can I use it. How to easily set up ADO using VBA code. How to use SQL to perform a simple query. How to write the query results to a worksheet....
by Paul Kelly | | Building Applications, Vault Video
Webinar Number: W0057 This webinar features: What are arrays and why do you need them? 100x your code speed by using arrays instead of ranges How to read through arrays How to copy arrays How to avoid the pitfalls that catch many array newbies out How to create...
by Paul Kelly | | Building Applications, Vault Video
Webinar Number: W0056 This webinar features: Real-world code examples. What is the Dictionary and why do you need it? Practical uses of the dictionary. How to write the Dictionary keys and items to a Range without a loop How to easily fix any issue with the Dictionary...