Excel.Application.Quit

  • Thread starter Thread starter Bob B.
  • Start date Start date
B

Bob B.

When I issue Excel.Application.Quit from Access to close an Excel Worksheet,
I am asked if I want to Save the Worksheet. Is there a switch or option that
will supress this? I wil never want to save for this particular application
even if updates are made to the Worksheet. Thank you in advance for any
assistance you can provide.
 
Hi Bob,
with Excel.Application.DisplayAlerts = False you switch off the XL messages.
To switch on again the messages use Excel.Application.DisplayAlerts = True

HTH Paolo
 
In addition to Paolo's suggestion, you can also iterate through all the
Workbooks and issue a Workbook.Close command for each, with the appropriate
option set for SaveChanges (depending whether you want to save them or close
them).


Rob
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Closing Excel from Access 2
close excel; leave access open 1
Counting multiple memberships 1
Excel Columns moving up and down on their own in a worksheet. What Goes? 2
New at this Excel VBA game and very perplexed 19
Run-Time error '3349': Numeric field overflow. 0
Running Excel Addin from VBA in Access....HELP!! 9
IE to Book1, to book2, then close Book1.xls 3

Back
Top