PDA

View Full Version : Solved: Can you 'export' a macro?



Lester
10-31-2007, 06:44 AM
Excuse my ignorance on the subject (...hence the question), but is it possible for a macro to exist on its own in a directory/folder on a drive, thus allowing any excel file to import it for its own use?
I've created a few macros and want them to be available to excel files which need to use them.
Any ideas? Can macros be exported to a folder?

mdmackillop
10-31-2007, 06:51 AM
You can export a module as a bas file (File/Export from the VBE) and import it from another workbook

Lester
10-31-2007, 06:54 AM
Thanks md, I've created the .bas file successfully. Cheers.