LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 26
Default More efficient memory deallocation

Hello again,

I have code which involves many objects that have references to each other.

This causes large memory leaks since VBA is not able to deaalocate all
memory that has gone out of scope. So, I set all references, etc to NOTHING
when the objects terminate. Problem is there is still a significant memory
leak AND it is quite time consuming.

So does anyone know of a fast way to deallocate memory? The Unload
statement does not seemto help either.

What might be ideal is maybe a windows API function that deallocates memory.
In theory we should be able to point to an address in memory and a size of
the object structure and free that memory. Does anyone have know the details
of we can do something like that?

Any insights would be greatly appreciated.

Thanks,

Chris (ct60)
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
XL 2007 - Out of Memory - memory leak/bug? PCLIVE Excel Discussion (Misc queries) 0 March 23rd 09 03:31 PM
more efficient VBA? markx Excel Programming 4 August 7th 06 05:41 PM
More efficient way? Steph[_3_] Excel Programming 6 June 23rd 04 09:34 PM
Which is more efficient? Norm[_5_] Excel Programming 3 April 2nd 04 04:24 PM
The instruction at "0x65255ac9" referenced memory at "0x00000008". The memory could not be read. Clikc OK to terminate etc Angus Comber[_2_] Excel Programming 1 November 7th 03 01:18 PM


All times are GMT +1. The time now is 08:44 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"