View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Sharon[_5_] Sharon[_5_] is offline
external usenet poster
 
Posts: 6
Default Prompt user to save their file

I am trying to prompt the user to save their file.

Application.GetSaveAsFilename looks like the right window
that pops up but the file doesn't actually save.

I tried this: ActiveWorkbook.SaveAs(Filename:=fName)
thinking I could set up a variable but maybe I have the
syntax wrong because it is not working.

Any ideas?
Thanks,
Sharon