Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Macro to save file in changing directories? | Excel Programming | |||
Open Excel with a XML file and SaveAs XLS | Excel Programming | |||
Open Test file with VBA with a changing file number | Excel Programming | |||
File Open doesn't display all directories (List vs Details) | Excel Discussion (Misc queries) | |||
Open delimited text file to excel without changing data in that file | Excel Programming |