How to export macro to another computer automatically

[Flabbergaster]

Hi
For a while now I've been working on a macro to compute all sorts of extra calculations in an output-sheet from a geometric data ananlysis program. I've found and asked for a lot tips on this board - thank you all.
I've saved the macro in my personal.xls, and added a "button" in Excel to make it easy to run the calculation in any output-sheet.

My next question which might sound a bit off-board. Does anyone know if it's possible for me make some kind of executable file that someone else (a college) can run, and have it all imported to his personal.xls, with the button too.

[JBeaucaire]

Probably what you want to do is create your own "addin" people can load into their excel permanently, and remove easily later, if they want.

If you Google "Excel Create Add In" you'll 100s of online tutorials on this topic.

http://msdn.microsoft.com/en-us/libr...ice.10%29.aspx

http://www.fontstuff.com/vba/vbatut03.htm