| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
File dosn't always close?
Using
Application.Close Application.Quit the file appears to still be open sometimes any ideas? |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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? |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Indirect.EXT download dosn't exist | Excel Worksheet Functions | |||
| MS querry dosn't work when importing from DB2 after upgrading to 2 | Excel Worksheet Functions | |||
| Everytime i close an excel file, it creates a new backup file | Excel Discussion (Misc queries) | |||
| VBA - on a button event, open another closed file, post changes, close file | Excel Programming | |||
| Automate open file, update links, run macro, close and save file | Excel Programming | |||
Hybrid Mode
