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.

SwiftCode wrote:

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