Most Valuable Professional


View Jan Karel Pieterse's profile on LinkedIn subscribe to rss feed
Subscribe in a reader

Subscribe to our mailing list

* indicates required

Audit !!!

Check out our RefTreeAnalyser
the ultimate Excel formula auditing tool.

Trainings

Excel VBA Masterclass (English)
Excel VBA for Financials (Dutch)

Third party tools

Speed up your file

FastExcel
The best tool to optimise your Excel model!

What has changed?

PerfectXL Compare, for Spreadsheet Comparison
This Excel compare tool is fast, reliable, and easy to use. Compare two Excel files now and see for yourself!
Home > English site > Articles > Create add-ins
Deze pagina in het Nederlands

Creating An Add-in From An Excel Macro.

This article has been published in the Dutch Office magazine (number 25, April 2005 and 26, July 2005)

Introduction

Excel is one of the most frequently used applications in business. The program is packed with standard functions and options, but also offers Visual Basic for Applications to automate repetitive tasks or even write your own functions. Many users start by recording their actions into a macro. They soon discover that the macro recorder delivers code that needs tweaking and thus start programming VBA.
Sometimes a user has developed a macro that is so useful that it would be interesting to hand it over to others as well.
At that point, the macro will have to be made ready for distribution. This article gives an overview of the things that need to be taken into account to do this.

Table Of Contents