ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Sharing macros - extreme newbie question I know. (https://www.excelbanter.com/excel-programming/313430-sharing-macros-extreme-newbie-question-i-know.html)

rfalke

Sharing macros - extreme newbie question I know.
 

I have written several macros in excel that present a form to the use
then connects to a database to bring in information directly to th
spreadsheet. My question is: How do I install (I guess that is th
correct word) these macros on others machines so they can use thes
macros? Are Add-Ins the answer? I have created an Add-In but no
what? Your replies are greatly appreciated. Thanks

--rya

--
rfalk
-----------------------------------------------------------------------
rfalke's Profile: http://www.excelforum.com/member.php...fo&userid=1526
View this thread: http://www.excelforum.com/showthread.php?threadid=26893


Tom Ogilvy

Sharing macros - extreme newbie question I know.
 
Put the addin in a central location. then the user can do Tools=Addins and
nagivate the addin and select it.

However, you need to have your addin create a toolbar or menu to run the
macros, because the macros in the addin will not be visible in
Tools=Macro=Macros.

--
Regards,
Tom Ogilvy

"rfalke" wrote in message
...

I have written several macros in excel that present a form to the user
then connects to a database to bring in information directly to the
spreadsheet. My question is: How do I install (I guess that is the
correct word) these macros on others machines so they can use these
macros? Are Add-Ins the answer? I have created an Add-In but now
what? Your replies are greatly appreciated. Thanks

--ryan


--
rfalke
------------------------------------------------------------------------
rfalke's Profile:

http://www.excelforum.com/member.php...o&userid=15269
View this thread: http://www.excelforum.com/showthread...hreadid=268935





All times are GMT +1. The time now is 11:41 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com