You might try recording a macro using File:Open, Tools, Find, and setting
your target folder, file type, and Text or Property values.

Ed

"Roger1947" wrote in message
...
Hi all,

I am looking to write a Excel XP vba code which will allow me to search
for a specific search string in a Excel macro module for all the "xls"
spreadsheet type files in the folder location which will prompt me which
could be "C:\" .

For example..I want to search all the spreadsheets for the string
"C:\temp" hardcoded into the Excel XP macro module using an automated
solution like Excel XP VBA.

I am using Excel XP on Windows XP o/s.

Please help me out with the code as I have to present a report to my
manager in 2 days.

Thanks,
Roger.
E-mail: