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.)
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.)