File dosn't always close?
 

Using

Application.Close
Application.Quit

the file appears to still be open sometimes

any ideas?

File dosn't always close?
 

Hi Karl

Application.Close
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



--
Regards Ron de Bruin
http://www.rondebruin.nl


"Karl Treier" wrote in message ...
Using

Application.Close
Application.Quit

the file appears to still be open sometimes

any ideas?

File dosn't always close?
 

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

"Karl Treier" wrote in message
...
Using

Application.Close
Application.Quit

the file appears to still be open sometimes

any ideas?