Fetching VBA "Source Code"

[MWE]

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

 

[Chip Pearson]

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