*Q:*How would I search for Excel files and only those that have VBA code contained inside of them? Any efficient ways to do this?
The way I'm thinking of would be to use vbscript and recursively search through the directory, open the excel file, and then search for VBA code... is there a better way?
I'm searching alot of files and would like to maximize my efficiency.
Okay the Answer for this question is listed on StackOverflow: See : http://stackoverflow.com/questions/10140030/how-to-determine-quickly-which-sheets-have-macros-in-excel-workbook