ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Changing file/open and file/saveas directories (https://www.excelbanter.com/excel-programming/402010-changing-file-open-file-saveas-directories.html)

jamjam

Changing file/open and file/saveas directories
 
Hi,

When i use the Pl/sql developer function 'copy to excel', it creates/opens
an excel file for me in the "c.\...\temp" directory".
Now when I am in this file and I use the file/open and file/save commands
excel defaults to the "c.\...\temp" directory".

I was wondering if anyone knows how to change the path of the file/open
file/saveas commands.( a small macro hopefully)
I would like to be able to save the file right at the "c:\" directory.

I am using excel2000 and windowxp.
If you need any more info, just ask. I am not very computer literate.

Thanks

John Bundy

Changing file/open and file/saveas directories
 
Try this...go to Tools-Options-General and set the default file location to
C:\
--
-John
Please rate when your question is answered to help us and others know what
is helpful.


"jamjam" wrote:

Hi,

When i use the Pl/sql developer function 'copy to excel', it creates/opens
an excel file for me in the "c.\...\temp" directory".
Now when I am in this file and I use the file/open and file/save commands
excel defaults to the "c.\...\temp" directory".

I was wondering if anyone knows how to change the path of the file/open
file/saveas commands.( a small macro hopefully)
I would like to be able to save the file right at the "c:\" directory.

I am using excel2000 and windowxp.
If you need any more info, just ask. I am not very computer literate.

Thanks



All times are GMT +1. The time now is 06:50 AM.

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