Need help to write Excel VBA to search all macro in Excel module for search string

R

Roger1947

Hi all,

I am looking to write a Excel XP vba code which will allow me t
search for a specific search string in a Excel macro module

for all the "xls" spreadsheet type files in the folder location whic
will prompt me which could be "C:\" .

For example..I want to search all the spreadsheets for the strin
"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 m
manager in 2 days.

Thanks,
Roger.
E-mail: (e-mail address removed)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top