Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default Need code to copy from "code modules"


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

  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 691
Default Need code to copy from "code modules"

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" wrote in message
...

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



  #3   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1,120
Default Need code to copy from "code modules"

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" wrote in
message ...

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



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How to use VBA to copy this code to "thisworkbook" objects of all opened workbooks ? Amolin[_2_] Excel Programming 5 June 3rd 05 08:34 AM
Need to compare code in multiple modules to a master copy Dave[_2_] Excel Programming 4 November 17th 04 02:09 PM
Can you "duplicate" "copy" listboxes and code to multiple cells? HotRod Excel Programming 1 September 1st 04 05:03 PM
excel.application.run macro1 -- added code to respond "yes" to a inputbox Michael Joe Excel Programming 3 August 13th 04 10:11 PM
Looking for VB code to test for "RING" , "BUSY" disconnects or other signals BruceJ[_2_] Excel Programming 3 November 20th 03 01:55 AM


All times are GMT +1. The time now is 04:55 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"