Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Excel / Programming / November 2007

Tip: Looking for answers? Try searching our database.

Changing file/open and file/saveas directories

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
jamjam - 30 Nov 2007 16:24 GMT
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 - 30 Nov 2007 16:48 GMT
Try this...go to Tools->Options->General and set the default file location to
C:\
Signature

-John
Please rate when your question is answered to help us and others know what
is helpful.

> Hi,
>
[quoted text clipped - 11 lines]
>
> Thanks
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.