You can easily export and import modules: in VBA Project Explorer right click
on the module, choose export, it creates a .BAS file, it then can be imported
in a similar way by the other party. Place your new macros you want to
exchange into a separate module, so you can use this method.

Regards,
Stefi


€žGreg€� ezt Ã*rta:

Is there a way to export and import specific macros instead of all macros?

This is the situation:
A co-worker and I share the same macros and up until a few months ago we
used to keep our macros updated by transfering the "Excel11.xlb" file located
at "C:\Documents and Settings\(user_profile)\Application
Data\Microsoft\Excel."
For a while now we have been making our own personal macros. Now if one of
us creates a macro and the other needs just that macro, how can we export and
import just that specific macro instead of transfering the entire file thus
overwriting any of the other persons personal macros?

Thanks in advance,
Greg