external macro?

[JasonMac]

Hey, I don't know if this is possible but lets say i made a macro called "test" and exported the .bas file to C:\
is there a way to make a new macro that would call to C:\test.bas and run the code in it?

 

[Legacy 98055]

No. Not practically. Most people keep such functions in Personal.xls. Two other options available are storing your code in any workbook and then setting a reference to it from the workbook that will be utilizing the stored code. Similiar in function, compile your code into a dll.

What are you trying to do? Why do you feel the need to store your code elsewhere?