| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
File save location with Application.GetSaveAsFilename
Iım currently using the following ... fn = Application.GetSaveAsFilename(InitialFileName:=²Pl ease Enter Filename², Title:="Save As...") It keeps returning the file path of the users default file save location ... Can I set it using the macro? Chdir just before this line doesnıt seem to work ... Thanks. |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
File save location with Application.GetSaveAsFilename
File save location with Application.GetSaveAsFilenameif the directory is on
another drive than the currently default drive, then you have to change drives as well - best to do it anyway Chdrive "C' Chdir "C:\My Documents" fn = Application.GetSaveAsFilename( . . . -- Regards, Tom Ogilvy Brad Patterson wrote in message ... I'm currently using the following ... fn = Application.GetSaveAsFilename(InitialFileName:="Pl ease Enter Filename" , Title:="Save As...") It keeps returning the file path of the users default file save location ... Can I set it using the macro? Chdir just before this line doesn't seem to work ... Thanks. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| why can't i browse to a location to save a flat file | Excel Discussion (Misc queries) | |||
| Save File in Desired Location & Name | Excel Discussion (Misc queries) | |||
| how to save the same file in other location | Excel Discussion (Misc queries) | |||
| How change the file location that I save my files to? | Excel Discussion (Misc queries) | |||
| have excel prompt for a file name and save location | Excel Discussion (Misc queries) | |||
Linear Mode
