close without save silently.
 

closing excel workbook no save without save messagebox

close without save....

*** Sent via Developersdex http://www.developersdex.com ***

close without save silently.
 

Someworkbookvariable.close savechanges:=false



x taol wrote:

closing excel workbook no save without save messagebox

close without save....

*** Sent via Developersdex http://www.developersdex.com ***

--

Dave Peterson

close without save silently.
 

but, if the workbook has change working, and then when the workbook
close, save messagebox is shown.

i want to close the workbook without shown the messagebox

*** Sent via Developersdex http://www.developersdex.com ***

close without save silently.
 

Hi X Taol,

but, if the workbook has change working, and then when the workbook
close, save messagebox is shown.

Dave's suggestion works for me.

Setting the SaveChanges agument to False should close the file without any
message.


---
Regards,
Norman