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.
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
_________________
Microsoft MVP 2010 - Excel
Visit: Jerry Beaucaire's Excel Files & Macros
If you've been given good help, use theicon below to give reputation feedback, it is appreciated.
Always put your code between code tags. [CODE] your code here [/CODE]
“None of us is as good as all of us” - Ray Kroc
“Actually, I *am* a rocket scientist.” - JB (little ones count!)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks