View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Jay Jay is offline
external usenet poster
 
Posts: 671
Default Can VBA copy all procedures from one worksheet module to another?

Hi All -

Is there a way to programmatically copy VBA code from one worksheet module
to another in the same workbook?

Copying the worksheet (and its code module) is not an option because we are
looping through many copies and run into the documented Excel error
associated with copying too many worksheets in the same workbook.

Need something similar to Export File... and Import File..., but for
worksheet modules. Also, it would be desirable not to have to export to an
external file if possible.

--
Jay