How to search files using EXCEL codes?

  • Thread starter Thread starter Jiajin
  • Start date Start date
J

Jiajin

Dear All:
I wrote a program under EXCEL2003 using "Application.FileSearch" to search
the file. The program asks the user to give a file name for saving result
data. The purpose of "Application.FileSearch" is to find if an exist file has
the idendical name with the name given by user. It works OK under EXCEL2003.
But when the program runs under EXCEL2007, a run-time error displys: "Object
doesn't suppot this action".

I don't know how to modify the code for such function. Please help me.
Thanks a lot.
 

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

Solution for Application.FileSearch Excel 2007-2010 2
How to call a macro from a xlam in a xlsm 3
Open txt file using vba code 2
Custom toolbars in Excel2007 1
using application.filesearch for searching text in PDF 2
Getting FileName from Search 4
application.filesearch error in excel 2007 5
Filesearch error in Excel 2007 4

Back
Top