Sharing my macros that I have saved in Personal.xls

[Jugglertwo]

I would like to share some macros with my co-workers. Presently, I have
several that I have saved in the Personal.xls workbook.
1) What is the best way to share these macros with them?
2) I know that the Personal.xls workbook is saved in the XLSTART folder. Do
I just send them a copy of this workbook as an attachment and have them put
this file in their XLSTART folder?
3) Am I asking for trouble if I attend to share macros at work?
Any info and/or suggestions would be greatly appreciated !
Jugglertwo

 

[Gord Dibben]

I wouldn't mess around with replacing others' Personal.xls files which may
contain their own macros.

You can stick all your macros into one module in Personal.xls then export that
as a *.bas file.

Send that to them by email and they can import that *.bas file as a module into
their Personal.xls file.

Or Save As Personal.xls as an add-in(*.xla) and send that to them so's they can
load it through Tools>Add-ins.


Gord Dibben MS Excel MVP

 

[Nick Hodge]

Sending them your personal.xls is very dangerous as they may already have
one that does stuff.

You can export the code via the VBE (Alt+F11) and right click on the modules
and select export and vice versa on their machine. You need to be aware
that some stuff may not work if their machine is not set up similarly to
yours, e.g ODBC, versions, etc.

The safest way is to write code and save it as an add-in. This way they can
load in via Tools>Add-Ins... and there will be no macro warning, etc. The
code needs to be written to the same rules as all other code though, (as
above)

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
(e-mail address removed)
web: www.nickhodge.co.uk
blog (non-tech): www.nickhodge.co.uk/blog/

 

[NewGuy]

If you go into the VBE (Tools, Macro, Visual Basic Editor), you'll see your
macros listed on the left hand column of the screen. If you right-click on
them, there is an option to export the file. Click on that, select your
destination and click export.

Open the workbook you want to use the macro in and go back to the VBE. Go to
File and select Import File. Then your macros should be shared.

Note that if your macro refers to a specific workbook, it may not work.