Searching All Excel VBA Files for macros

  • Thread starter Thread starter Noel Luke
  • Start date Start date
N

Noel Luke

I wrote a vba loop that saves the file being processed every 20
iterations. But I have so many Excel files that I'm having troubl
finding this particular macro. I'm running on MS XP and used the X
search feature with file type set to Excel vba and no matter what
search for, e.g., "activecell?, I find nothing? What am I doing wrong?

Noe
 
You may get lucky if you use windows start button|Search/find to look for a
string you know is in the code.

Activecell may appear too many times to be a really useful search term (but
maybe not???).
 
You must log in or register to reply here.

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

Similar Threads

How to search Excel files based on a specific text string in VBA c 1
Excel Query setup 0
'Cannot insert object' message when I try to put a button on a worksheet 7
Importing any excel files with any sheet name into different tables in MSAccess using code 0
How do you do the following using VBA macro automatically? 1
search folder/directory for a phrase inside excel files 5
UDF can't be editted due to Excel 4 macro? 2
enable macros in 2007 1

Back
Top