Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
change default file path in Save As dialog box
Hi,
Need expert advice he How can I change the default file path appearing in the Save-As dialog box using VBA? I have a workbook application stored at, say, C:\MyProgram, I want the user save their file automatically at a different location, say, c:\my document,when they click Save or Save As Thanks much in advance. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
change default file path in Save As dialog box
Hi
use the statement chdir "c:\my document" before invoking the dialog -- Regards Frank Kabel Frankfurt, Germany charles wrote: Hi, Need expert advice he How can I change the default file path appearing in the Save-As dialog box using VBA? I have a workbook application stored at, say, C:\MyProgram, I want the user save their file automatically at a different location, say, c:\my document,when they click Save or Save As Thanks much in advance. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
change default file path in Save As dialog box
Frank,
Thanks, but I found it not working...when I click File, Save As, the default path is still the one where the workbook is opened. I want to define a different one. Regards, Charles "Frank Kabel" wrote in message ... Hi use the statement chdir "c:\my document" before invoking the dialog -- Regards Frank Kabel Frankfurt, Germany charles wrote: Hi, Need expert advice he How can I change the default file path appearing in the Save-As dialog box using VBA? I have a workbook application stored at, say, C:\MyProgram, I want the user save their file automatically at a different location, say, c:\my document,when they click Save or Save As Thanks much in advance. |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
change default file path in Save As dialog box
From a reply to a very similar question:
Since xl2k (IIRC), if you open a file, excel will show you that file's folder when you do a file|saveAs. And since you're going to that OLK5 location, I'm betting you're reading an attachment in your email--that's where your email stores the file when you click on it to read it. I don't know of a way to change this behavior. (But I'm usually glad it works this way. If I open one of my own files and do a File|SaveAs, I usually want to save it in the same folder.) And I do agree that it's a pain with attachments to emails. But hope isn't lost Since you're using xl2003, you can do this: Next time you're in the File|open (or File|SaveAs) dialog, traverse to your favorite folder (but just select it--don't go into it) Then click Tools|Add to My Favorites. Now, you can just click on that shortcut in the "look in" toolbar (left hand side of the File|open/SaveAs dialog). ==== If you're using xl2k: You could use an addin from MS: It's called Places.exe that allows you to update the places list. http://support.microsoft.com/default...;en-us;Q253338 INFO: Office Developer Samples and Tools Available for Download (Q253338) Scroll about halfway down. charles wrote: Hi, Need expert advice he How can I change the default file path appearing in the Save-As dialog box using VBA? I have a workbook application stored at, say, C:\MyProgram, I want the user save their file automatically at a different location, say, c:\my document,when they click Save or Save As Thanks much in advance. -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Can't find AutoRecover file in path specified in Options dialog. | Excel Discussion (Misc queries) | |||
Default Cell Values & Save Changes Dialog Box | Excel Discussion (Misc queries) | |||
GetOpenFilename Dialog default path | Excel Programming | |||
Can I change ExCels default save path for saving add-ins ? | Excel Programming | |||
Getting the full path when from a File Open Dialog Box | Excel Programming |