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.
 
Back
Top