View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
 
Posts: 27,285
Default How to save file without the save message?

Which are you trying to work with

Thisworkbook (the workbook with the code)

or

ActiveWorkbook



Thisworkbook.Close SaveChanges:=True

or

ActiveWorkbook.Close SaveChanges:=True

--
Regards,
Tom Ogilvy

"Together " wrote in message
...
Hi,
How to save file after change without the save message? I read many
thead. But it do not work.

Application.DisplayAlerts = False
ThisWorkbook.Save
ActiveWorkbook.Close

This code does not save change!



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