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

--
Regards
Frank Kabel
Frankfurt, Germany


Todd Huttenstine wrote:
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