File save location with Application.GetSaveAsFilename

  • Thread starter Thread starter Brad Patterson
  • Start date Start date
B

Brad Patterson

I¹m currently using the following ...

fn = Application.GetSaveAsFilename(InitialFileName:=²Please 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.
 
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


I'm currently using the following ...

fn = Application.GetSaveAsFilename(InitialFileName:="Please 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.
 
Back
Top