Excel Macro question

[Guest]

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

 

[Guest]

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:

 

[Guest]

Awesome, thanks Stefi

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:

 

[Guest]

You are welcome! Thanks for the feedback!
Stefi


„Greg†ezt írta:

 

[Gord Dibben]

Greg

Info only..............

Macros do not reside in the Excel11.xlb file.

That file only saves the Menu and Toolbar customizations you have made.

Macros reside in workbooks, whether they be regular workbooks or add-ins.


Gord Dibben MS Excel MVP