On May 22, 3:38*pm, "Ron de Bruin" wrote:
Hi Fatz

This is removed from 2007
You can use Dir

See how i use it on this pagehttp://www.rondebruin.nl/copy3.htm

--

Regards Ron de Bruinhttp://www.rondebruin.nl/tips.htm



"Fatz" wrote in ...
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- Hide quoted text -

- Show quoted text -

Ron - Thanks for your help. I will be 100% honest and let you know
that I do not understand a thing on that site! I am a VBA rookie.
Can you copy and paste the section I should be looking at?

Thanks Again,
Chris