How to store VBA code examples?

Brian

Board Regular
Joined
Apr 24, 2002
Messages
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.)
 

Excel Facts

Remove leading & trailing spaces
Save as CSV to remove all leading and trailing spaces. It is faster than using TRIM().
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:
 
Upvote 0

Forum statistics

Threads
1,213,496
Messages
6,113,993
Members
448,539
Latest member
alex78

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top