ACCESS 2007 - APPLICATION.FILESEARCH 1

[Jean9]

For an application written in MS ACCESS XP, the Application.FileSearch works to locate files in a particular drive:
With Application.FileSearch
.NewSearch ' LOOK FOR FILES TO PROCESS
However, this same code in 2007 results in the following error:
"You entered an expression that has an invalid reference to the property FileSearch." Error.Number 2455. I looked this up in the help for 2007 and the same code is still provided to accomplish this task. What might I be missing? I checked the references and re-compiled in 2007. There were no compile errors found.
Thanks for any help,
J9

 

[PHV]

FileSearch has been removed from office 2007.
Have a look here:

http://chrisrae.com/vba/routines/clrfilesearch.html

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886