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.
|