Thread: Saving a workbook using VBA
View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.programming
Steve C40 Steve C40 is offline
external usenet poster
  
Posts: 1
Default Saving a workbook using VBA
Hi Michael,

Just pop some error handling around your code:

On Error GoTo ErrorHandler:
ActiveWorkbook.SaveAs ActiveWorkbook.Name
ErrorHandler:

Thanks,

Steve
Reply With QuoteReply With Quote