ExcelBanter - VBA search

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - VBA search (https://www.excelbanter.com/excel-programming/347655-vba-search.html)

James McDowell[_2_]

VBA search

Is there a way in VBA to search EXCEl files to see if they have a Module
attached?
AND is there a way to search the Module to a certian string?

I want to look for any Excel file on my c drive that has a VBA module with
the string "U:\\ABC\MYDATABSE.mdb" in it.

Tim Williams

VBA search

Lots of help here

http://www.cpearson.com/excel/vbe.htm

--
Tim Williams
Palo Alto, CA

"James McDowell" wrote in message
...
Is there a way in VBA to search EXCEl files to see if they have a Module
attached?
AND is there a way to search the Module to a certian string?

I want to look for any Excel file on my c drive that has a VBA module with
the string "U:\\ABC\MYDATABSE.mdb" in it.

All times are GMT +1. The time now is 12:10 AM.