View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
SteAXA SteAXA is offline
external usenet poster
 
Posts: 22
Default Macro to save a workbook

you mustn't use square brackets for declare Filename, that is

ActiveWorkbook.SaveAs Filename:=spath, _
FileFormat:=xlNormal, Password:="", WriteResPassword:="", _
ReadOnlyRecommended:=False, CreateBackup:=False