View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
mathew mathew is offline
external usenet poster
 
Posts: 75
Default file won't save!

Any idea why this line of code won't save the file?? The "Save AS" box comes
up the user hits save and the macro contiunes like nothing is wrong.
However, the file does not save. The vairable fname, which is the default
file name, is working fine!

FileSaveName = Application.GetSaveAsFilename(fname, filefilter:="Excel Files
(*.xls),*.xls")