Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel crashing intermittently on save or file close - caused by vba?
I have developed an Excel front end for an Access (Jet ver. 4) 2000 database
(using MS Office XP). The program works fine, I can add records, query the database, etc. using the forms I made, and so on. I have been modifying this app to fit other databases. In the process, I have discovered a problem where when I try to save, or when I try to close the app after saving, Excel crashes and must be restarted. This was only annoying until I just lost nearly an hour worth of work... I have no idea how to start troubleshooting the cause of the crashes. I can only assume it is something in the code I have written that is causing the issue... Thoughts on where else I should look? TIA D |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel crashing intermittently on save or file close - caused by vba?
I got similar when not handling userforms correctly. Creating a new userform
object, show modal and let the procedure exit. The userform still displays, but the memory is unallocated. Stange things happen to Excel. -- Rob van Gelder - http://www.vangelder.co.nz/excel "dirt" wrote in message . .. I have developed an Excel front end for an Access (Jet ver. 4) 2000 database (using MS Office XP). The program works fine, I can add records, query the database, etc. using the forms I made, and so on. I have been modifying this app to fit other databases. In the process, I have discovered a problem where when I try to save, or when I try to close the app after saving, Excel crashes and must be restarted. This was only annoying until I just lost nearly an hour worth of work... I have no idea how to start troubleshooting the cause of the crashes. I can only assume it is something in the code I have written that is causing the issue... Thoughts on where else I should look? TIA D |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel crashing intermittently on save or file close - caused by vba?
Rob, thanks. That was it, when I ran the app the way it was designed, no
problem. When I was developing (fiddling with it I mean...) it would crash when I didn't allow the userforms to properly unload before I saved and exited. D "Rob van Gelder" wrote in message ... I got similar when not handling userforms correctly. Creating a new userform object, show modal and let the procedure exit. The userform still displays, but the memory is unallocated. Stange things happen to Excel. -- Rob van Gelder - http://www.vangelder.co.nz/excel "dirt" wrote in message . .. I have developed an Excel front end for an Access (Jet ver. 4) 2000 database (using MS Office XP). The program works fine, I can add records, query the database, etc. using the forms I made, and so on. I have been modifying this app to fit other databases. In the process, I have discovered a problem where when I try to save, or when I try to close the app after saving, Excel crashes and must be restarted. This was only annoying until I just lost nearly an hour worth of work... I have no idea how to start troubleshooting the cause of the crashes. I can only assume it is something in the code I have written that is causing the issue... Thoughts on where else I should look? TIA D |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel - No Longer Prompted to Save When I Close File | Excel Discussion (Misc queries) | |||
Each time I close an Excel file, it asks if I want to save. | Excel Discussion (Misc queries) | |||
File close excel does not ask me to save changes | Excel Discussion (Misc queries) | |||
I can't save a file unless I close all excel instances or it's th. | Excel Discussion (Misc queries) | |||
Excel Caused Error in VBE6.dll. Excel will Close | New Users to Excel |