Need code to copy from "code modules"

[davidm]

I am looking for (looping) code to copy the contents of the Personal.xls project onto a worksheet (say, Sheet1). I have in excess of 50 modules with some modules containing up to 8 sub procedures and functions.

TIA

[David McRitchie]

See Chip Pearson's page Coding for the VBE
http://www.cpearson.com/excel/vbe.htm
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"davidm" <[email protected]> wrote in message
news:[email protected]...
>
> I am looking for (looping) code to copy the contents of the
> Personal.xls project onto a worksheet (say, Sheet1). I have in excess
> of 50 modules with some modules containing up to 8 sub procedures and
> functions.
>
> TIA
>
>
> --
> davidm
> ------------------------------------------------------------------------
> davidm's Profile: http://www.excelforum.com/member.php...o&userid=20645
> View this thread: http://www.excelforum.com/showthread...hreadid=386038
>

[Bob Phillips]

If you want to analyse that code, why not use Rob Bovey's code documenter
http://www.appspro.com/Utilities/Documentor.htm

--
HTH

Bob Phillips

"davidm" <[email protected]> wrote in
message news:[email protected]...
>
> I am looking for (looping) code to copy the contents of the
> Personal.xls project onto a worksheet (say, Sheet1). I have in excess
> of 50 modules with some modules containing up to 8 sub procedures and
> functions.
>
> TIA
>
>
> --
> davidm
> ------------------------------------------------------------------------
> davidm's Profile:
http://www.excelforum.com/member.php...o&userid=20645
> View this thread: http://www.excelforum.com/showthread...hreadid=386038
>