Excel 2003 slow on Memory Deallocation

[bojisheng]

We have an excel spreadsheet app (in VBA) that uses DAO. The app works fine. After exiting the spreadsheet, any other app (operating system level interface seems fine) seems unresponsive. (I am pretty sure that this is not the SMB signing issue in MSKB Article 814112).

We did notice that Excel.exe is in the task manager processes list with the Memory decreasing (starting at about 40+Meg) ohhhh so slowly (100 K a second or so) until it suddenly drops to about 20M and everything is responsive.

I am reviewing the VBA code to ensure that objects are set to nothing. I do not know if closing and reopening the DAO connection as needed would help or hurt the situation.

Has anyone else experienced anything similar? Resolution? Suggestions?
Thanks in advance

 

[SkipVought]

memory leaks in Excel is not uncommon.

have you been setting objects to NOTHING once you close connection/recordset? If not, that can eat up memory, but does not solve all memory leaks.

Skip,
[sub]
[red]Be advised:[/red]When Viscounts were guillotined just as they were disclosing where their jewels were hidden, it shows to go that you should...
Never hatchet your Counts before they chicken! [/sub]

 

[bojisheng]

Thanks for the tip. I will be checking that first thing next week.

Regardless if it is a leak, it is the time it takes to release the memory. I don't know if it is going thru executing distructor methods for items that were not already set to nothing. or maybe it doesn't execute the destroy until it absolutely has to...like when one closes the workbook.

I will stop babbling now...I will review my code for a missing set nothing when I close the recordset.

Thanks.