Distributing Excel Macros and Forms

[Zukkster]

What is the best way to distibute an Excel (2003) macro and a form that's associated with it? Version control, as it's own workbook

What are the pitfalls and things to look out for?

Are there any specific things I need to do with my code?

I appreciate this may be a large topic, so links to helpful articles would be useful

Thanks in advance

 

[AnotherHiggins]

Here's an easy way to turn a macro into a custom menu item:

http://j-walk.com/ss/excel/tips/tip53.htm

[tt]_____
[blue]-John[/blue][/tt]
[tab][red]The plural of anecdote is not data[/red]

Help us help you. Please read FAQ181-2886 before posting.

 

[firefytr]

Hi there,

I would make sure that you modulize everything. Meaning that anything that you may want updated, try keeping it all together and referenced well. Do this so when you need to change out code or upgrade it's just a matter of replacing a module or form and not a major overhaul. I would expect for you to play with it for a little while.

There aren't really anything specific you'd need to do with your code unless you need to code specifically around a situation you may have there, but that wouldn't refer to deployment, more towards development. Check out a few tips here, here, here (dotNet), here (developer documentation), here and here.

Some other questions that may change the outcome that you should think about: Is this going to be a shared addin? Stored on a network drive? Programmed with Excel/VBA, VB6, C#/++?

HTH

Regards,
Zack Barresse

Simplicity is the ultimate sophistication. What is a MS MVP? PODA
- Leonardo da Vinci

 

[Zukkster]

Excellent. I found what I was looking for via one of firefytr's links.

The magic word appears to be Add-ins.

Once I knew this I had a dig around on the Internet and hey presto. The following link

http://www.jkp-ads.com/articles/DistributeMacro00.htm

was excellent at helping me through the code required to;

hide the code
create the buttons
load toolbars

and all the other stuff necessary to make it user friendly.

Ta