File dosn't always close?

  • Thread starter Thread starter Karl Treier
  • Start date Start date
K

Karl Treier

Using

Application.Close
Application.Quit

the file appears to still be open sometimes

any ideas?
 
Hi Karl
Application.Close
Click to expand...
This will not close a workbook

If you use this for example the workbook will be closed without saving

ThisWorkbook.Close SaveChanges:=False
If you want to save change it to True
 
Do you have an object set to the file or the application? If so, try using
your object references to close and quit, and then set the objects =
Nothing.

HTH
Ed
 
You must log in or register to reply here.

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

difference application.quit & application.close 4
Re: VBA Runs After Application.Quit 11
VBA - Closing Outlook 1
VBA Code Locked for Viewing 7
Forms ran as EXE 1
How can I force a workbook to close? 6
Force Excel to close 6
Open a New Instance of Excel 3

Back
Top