ExcelBanter - Dir Path

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - Dir Path (https://www.excelbanter.com/excel-programming/293865-dir-path.html)

Todd huttenstine

Dir Path

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

Dir Path

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

All times are GMT +1. The time now is 08:45 PM.