View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
pikus pikus is offline
external usenet poster
 
Posts: 1
Default Opening a saved file

If you copied and pasted your code directly from your file, make sure
you add line continuation characters, or paste this in instead:

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

If you turn off the alerts you won't see any errors that happen while
this is running, so if the above code doesn't work, turn the alerts
back on and see what they say. Then, if you can't answer your own
question, post the alerts here so I can see them. - Pikus


---
Message posted from http://www.ExcelForum.com/