How to store VBA code examples?

Brian · May 5th, 2002, 03:36 PM

Hi, I've been collection VBA samples from various places but sometimes forget what file something is in.

Has anyone written a script to open every spreaadheet in a directory, and copy the names of all of the subroutines (and any immediately following comments) to a workbook?

Same thing for all sheet names?

I could do this myself, so you only need to reply if you have something similar already : ie.
1) cycles through all files in a folder
2) cycles through all VBA subroutines and functions in a file.

Regards

Brian
BW-NoSPAM1@earthlink.com

(I tried to post this earlier today but it dod not show up on the board.)

Jack in the UK · May 5th, 2002, 03:59 PM

I am sucking eggs but////////////////

Export as BAS files and thats that o Ok yxy is col

i would load intio personal Xls ..

noy to many array or udf fle funcions thou:

May 5th, 2002, 03:59 PM	#2
Jack in the UK Board Regular Join Date: Feb 2002 Posts: 3,065	I am sucking eggs but//////////////// Export as BAS files and thats that o Ok yxy is col i would load intio personal Xls .. noy to many array or udf fle funcions thou: __________________ Free Excel based Web Toolbar available here. Jack in the UK J & R Excel Solutions "making Excel work for you"

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

May 5th, 2002, 03:36 PM	#1
Brian Board Regular Join Date: Apr 2002 Posts: 113	Hi, I've been collection VBA samples from various places but sometimes forget what file something is in. Has anyone written a script to open every spreaadheet in a directory, and copy the names of all of the subroutines (and any immediately following comments) to a workbook? Same thing for all sheet names? I could do this myself, so you only need to reply if you have something similar already : ie. 1) cycles through all files in a folder 2) cycles through all VBA subroutines and functions in a file. Regards Brian BW-NoSPAM1@earthlink.com (I tried to post this earlier today but it dod not show up on the board.)