Fetching VBA "Source Code"

  • Thread starter Thread starter MWE
  • Start date Start date
M

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
 
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
 
Back
Top