Fetching VBA "Source Code"
 

Is there some way to "fetch" (using VBA) VBA source code
from the Module area of another workbook and drop it into
a directory as a .bas file?

Thanks

Fetching VBA "Source Code"
 

See www.cpearson.com/excel/vbe.htm for various techniques for
manipulating VBA code with VBA code. You can combine some of the
techniques there to copy a procedure from one module to another
module, then use the Export method to write the module out to a
bas file.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com



"MWE" wrote in message
...
Is there some way to "fetch" (using VBA) VBA source code
from the Module area of another workbook and drop it into
a directory as a .bas file?

Thanks