Using Application.Close Application.Quit the file appears to still be open sometimes any ideas?
K Karl Treier Aug 5, 2004 #1 Using Application.Close Application.Quit the file appears to still be open sometimes any ideas?
R Ron de Bruin Aug 5, 2004 #2 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
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
E Ed Aug 5, 2004 #3 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
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
