Installing a Macro at multiple computers

abbo · Apr 23rd, 2002, 10:30 AM

Ok, I am new here so be nice to me please.

What I am trying to do is install an Macro to several different workstations. I will need about 50 users to be able to access the macro and run it. I would love to put it as an "add-in" to Excel if I could.

Does anybody have any experience doing this? Any input or questions would be greatly appreciated.

Mark O'Brien · Apr 23rd, 2002, 11:03 AM

I am assuming that your macro is situated in a workbook and that it runs fairly automatically. i.e. when the workbook opens or something.

To turn this file into an Add-In, simply go to File|Save As, then in the File Type combo box (where it says Excel File *.xls, or whatever) choose the last option which should be "Excel Add-In". Simply give this to your users and the when they open it up, Excel should do the rest.

HTH

abbo · Apr 23rd, 2002, 12:27 PM

Thank you very much. I will give this a try. Seems so simple. I can't believe I didn't think of it myself.

Apr 23rd, 2002, 11:03 AM	#2
Mark O'Brien MrExcel MVP Join Date: Feb 2002 Location: Columbus, OH, USA Posts: 3,519	I am assuming that your macro is situated in a workbook and that it runs fairly automatically. i.e. when the workbook opens or something. To turn this file into an Add-In, simply go to File\|Save As, then in the File Type combo box (where it says Excel File *.xls, or whatever) choose the last option which should be "Excel Add-In". Simply give this to your users and the when they open it up, Excel should do the rest. HTH __________________ Mark O'Brien Columbus Ohio Celtic Supporters Club

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Apr 23rd, 2002, 10:30 AM	#1
abbo New Member Join Date: Apr 2002 Posts: 3	Ok, I am new here so be nice to me please. What I am trying to do is install an Macro to several different workstations. I will need about 50 users to be able to access the macro and run it. I would love to put it as an "add-in" to Excel if I could. Does anybody have any experience doing this? Any input or questions would be greatly appreciated.

Apr 23rd, 2002, 12:27 PM	#3
abbo New Member Join Date: Apr 2002 Posts: 3	Thank you very much. I will give this a try. Seems so simple. I can't believe I didn't think of it myself.