Hi Fatz
This is removed from 2007
You can use Dir
See how i use it on this page
http://www.rondebruin.nl/copy3.htm
--
Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm
"Fatz" wrote in message ...
Hi-
I just upgraded to Office '07 and I am having trouble with some code.
The following code works in 97 but does not work in 2007.
With Application.FileSearch
.NewSearch
.LookIn = "N:\Sales\MAP ROLLUP"
.SearchSubFolders = False
.Filename = "*.xls"
.Execute
Does anyone know how to code the above in 2007?
Thank You!
Chris