ExcelBanter - how do i set file location path?

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

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

- - how do i set file location path? (https://www.excelbanter.com/excel-programming/309440-how-do-i-set-file-location-path.html)

dennis

how do i set file location path?

Tom Ogilvy

how do i set file location path?

Do you mean the default:
Chdrive "D"
Chdir "D:\MyFolder"

or for a specific file

ActiveWorkbook.SaveAs "D:\MyFolder\" & ActiveWorkBook.Name

--
Regards,
Tom Ogilvy

"dennis" wrote in message
...

All times are GMT +1. The time now is 01:04 AM.