View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Brad Patterson Brad Patterson is offline
external usenet poster
 
Posts: 16
Default 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.