Thread: VBA search
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Tim Williams Tim Williams is offline
external usenet poster
 
Posts: 1,588
Default 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.