ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Defaulty directory (https://www.excelbanter.com/excel-programming/304512-defaulty-directory.html)

greg

Defaulty directory
 
Hi,

Is there a way to have "Default file location" constantly
referencing the same default directory no matter where I
save a file?


Thanks,
Greg

Frank Kabel

Defaulty directory
 
Hi
AFAIK not possible with the build-in save functionality

-----Original Message-----
Hi,

Is there a way to have "Default file location" constantly
referencing the same default directory no matter where I
save a file?


Thanks,
Greg
.


greg

Defaulty directory
 
Thanks.

-----Original Message-----
Hi
AFAIK not possible with the build-in save functionality

-----Original Message-----
Hi,

Is there a way to have "Default file location"

constantly
referencing the same default directory no matter where I
save a file?


Thanks,
Greg
.

.


39N95W[_2_]

Defaulty directory
 

"greg" wrote in message
...
Hi,

Is there a way to have "Default file location" constantly
referencing the same default directory no matter where I
save a file?


Thanks,
Greg


From the Excel Tools | Options... menu choose the General tab. You can
specify a default directory there. My experience has been that this default
directory is used when prompting for a Save path when called from a VBA
subroutine.

-gk-




All times are GMT +1. The time now is 01:22 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com