The Excel VBA Masterclass, what to expect part 5
Add-ins are a powerful addition to Excel. Creating add-ins isn’t hard to do, but there are many things to consider when you decide to deliver your code in an add-in. In this section of the course we will touch on these subjects:
- When to use an add-in
as opposed to a “normal” workbook
- How to develop add-ins
Things to consider when you’re writing code for an add-in
- Automating installation
As simple as it may seem to you, many users have a hard time installing add-ins. Here’s how to help them (and make sure your add-in gets used)
- Updating Add Ins
Having one version of the truth is very important. Given that many people use laptops you may want your add-in to be available off-line too. This means a local copy of your add-in will reside on their C-drive. How can you ensure these copies stay up to date?
- Manual update using central location
Sometimes all users are connected to the network shares all the time, how can you make sure you can update an add-in used by many people?
- Programmatically updating an add-in
Doing it all automagically!
We’ll talk about UDFs extensively and (amongst other things) demonstrate how code in a UDF can be optimised for speed.