View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
 
Posts: 27,285
Default 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.