Thread: How to force close the worksheet without having Excel prompt?
View Single Post
  #2   Report Post  
Posted to microsoft.public.vb.general.discussion,microsoft.public.excel.programming
joel joel is offline
external usenet poster
  
Posts: 9,101
Default How to force close the worksheet without having Excel prompt?
From
moExcel2ndTask.Workbooks.Close

to
moExcel2ndTask.Workbooks.Close savechanges = true

or
moExcel2ndTask.Workbooks.Close savechanges = false

"Jack" wrote:

How to force close the worksheet without having Excel prompt?

Right now I use this:
moExcel2ndTask.Workbooks.Close
and the Excel prompt is:
"
Do you want to save changes to ...xls?
Microsoft Office Excel recalculates formulas when opening files saved by an
earlier version of Excel.
"
Thanks,
Jack



Reply With QuoteReply With Quote