PDA

View Full Version : execute excel



tommy1234
03-22-2008, 02:31 AM
Hi
i wrote a vba code for excel and i want that all the users who need the code will be able to use it from their computer without my excel file.
can i create an execute file that everyone can run from their computer ?
maybe there is a way to move my vba code to vb and connect to ado (if there is can someone help me)

thanks

Bob Phillips
03-22-2008, 02:33 AM
Create an addin and give it to them


http://support.microsoft.com/default.aspx?kbid=211563
How to create an add-in file in Excel 2000

http://support.microsoft.com/default.aspx?kbid=156942
XL97: How to Create an Add-in File in Microsoft Excel 97

http://support.microsoft.com/default.aspx?kbid=179008
MacXL: How to Create an Add-in File in Microsoft Excel


http://support.microsoft.com/default.aspx?kbid=160131
XL97: Cannot Modify Microsoft Excel 5.0 or 7.0 Add-in