Dir Path

[Todd Huttenstine]

FName = Dir("*.xls")

How do I specify in the above code that I want dir to be:

"\\scgvlfs05\sesfa\Stats2004\Contract Reports\Daily
Renewal Audits\March"

Thanks

Todd

 

[Frank Kabel]

Hi
use ChDir
prior to this statement
Also have a look at ChDrive