Storing macros outside of Excel VB

SwiftCode · Oct 16, 2003

Hi,

I was wondering whether it is possible to have Excel
call a macro from outside of the application and run it
within the spreadsheet itself (independently).

If it is possible, then how can I create such a macro,
and what do I need to do.

Thanks
Ray

Dave Peterson · Oct 17, 2003

Chip Pearson has some code that shows how to import a text file into your
modules:

http://www.cpearson.com/excel/vbe.htm

But maybe an alternative would be to create a macro workbook (or addin) that can
be executed on demand.

Storing macros outside of Excel VB

SwiftCode

Dave Peterson