MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Distributing macros

Posted by Bruce Wexler on October 29, 2001 9:18 AM


What is the best way to dist. macros? I have a macro that suppresses duplicates, and I need to distribute this to other users so they can run this. Do I save it as an Excel sheet and have them save that sheet in a certain folder? Or is there a more automated way to do this?


Bruce Wexler

Posted by EDDIE G on October 29, 2001 9:32 AM


Can I have a copy of your duplicate suppressing macro please? I need that type of macro. Sorry I can't answer your macro question.

Posted by Mark O'Brien on October 29, 2001 12:25 PM

You might want to try saving it as an Excel Add-in, *.xla.

If you do File|Save As and then in the "Save As Type" dropdown, the last option should be Excel Add-In. This will save your macros without the need for a workbook.

When the user receives the *.xla, tell them to open Excel, then go to Tools|Add Ins to get the Add Ins dialogue box. Then they can browse to wherever the .xla has been saved. They should then be asked if they want to add this .xla to the folder containing the MS add-ins e.g. the Analysis Toolpak etc.

Hope this helps.