Re: Need code to copy from "code modules"

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance



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" <davidm.1rzoib_1121058304.113@xxxxxxxxxxxxxxxxxxxxx> wrote in message
news:davidm.1rzoib_1121058304.113@xxxxxxxxxxxxxxxxxxxxxxxx
>
> 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?action=getinfo&userid=20645
> View this thread: http://www.excelforum.com/showthread.php?threadid=386038
>


.



Relevant Pages

  • Re: MS-Excel VBA file (XLA) saving problem
    ... The date/time changes for every file you open--that's just the way excel works. ... Are you positive that the .xla's project is the active project when you hit ... same till I close the MS-Excel. ... I've never had any trouble saving from the VBE (making sure that the .xla ...
    (microsoft.public.excel.setup)
  • Re: Cannot lock project
    ... I've seen changes in filesizes (sometimes minor changes make the filesize go up, ... I just figured that that's the way excel ... > Yes I've also read similar and don't normally save from the VBE. ... >> From Thomas Ramel: ...
    (microsoft.public.excel.programming)
  • RE: Excel Silently Crashing when Network file is open
    ... Vaya con Dios, ... "Scot McPherson" wrote: ... is just instantaneous, Excel "loses it's way back home", and locks up. ...
    (microsoft.public.excel.misc)
  • Re: Cannot lock project
    ... You mentioned that you had changed versions of Excel in you testing. ... >> I've never had a problem saving from the VBE, but I've read a few posts ... > Yes I've also read similar and don't normally save from the VBE. ... >> From Thomas Ramel: ...
    (microsoft.public.excel.programming)
  • Re: Need to solve for the total value of a commercial lease
    ... HTH:>) ... Windows XP & Excel 2007 ... *undiscounted* value of thelease. ...
    (microsoft.public.excel)