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

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

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