JKP Application Development Services.

                    Microsoft Office Application Development

The Dutch Office magazine has published the following article of mine (number 25, April 2005 and 26, July 2005):

Creating An Add-in From An Excel Macro.

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

1. Preparing A Macro For Distribution
2. Use A Workbook Or An Addin
3. Creating A Menu
4. Creating A Toolbar
5. Limiting Access To Your Code
6. Protect Your Code From Prying Eyes
7. Initialise Your Variables
8. Save User Settings
9. Use Different User Interface Languages
10. Create A Setup Utility
11. Conclusion

Introduction 1 2 3 4 5 6 7 8 9 10 Conclusion

    Subscribe in a reader

Use the contact page to issue questions or comments about this website.
Copyright © 2003-2008 JKP Application Development Services