FileSearch in Access 2007

A

Anthony Ching

I have a program that needs to search for files in individual folders.
However, the Application.FileSearch doesn't seem to be supported in access
2007.

Dim fs as object
Set fs = application.filesearch

I tried a different method using FileSystemObject. However, this doesn't
seem to be supported either.

Can someone help.
 
T

Tom van Stiphout

On Thu, 29 Jan 2009 18:20:00 -0800, Anthony Ching

I can't get that to work either. "You entered an expression that has
an invalid reference to the property FileSearch." I will investigate
further as time permits. The code here:
http://msdn.microsoft.com/en-us/library/aa190819(office.10).aspx is
not working for me either.

In the meantime, use the built-in Dir function to iterate over the
files in a folder.
Or create a Scripting.FileSystem object.

-Tom.
Microsoft Access MVP
 
Top