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

Chip Pearson has some code that might help:

http://www.cpearson.com/excel/vbe.htm#CopyModule

If you don't want to copy the whole module, browse around his site, I'm sure
you can find something that will help.

"Jay" wrote:

> 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

Thanks JLGWhiz. I'm adapting some of Chip's code now.
--
Jay


"JLGWhiz" wrote:

> Chip Pearson has some code that might help:
>
> http://www.cpearson.com/excel/vbe.htm#CopyModule
>
> If you don't want to copy the whole module, browse around his site, I'm sure
> you can find something that will help.
>
> "Jay" wrote:
>
> > 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