File save location with Application.GetSaveAsFilename

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

 

[Tom Ogilvy]

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.