View Single Post
 
Old 06-24-2014, 07:42 PM
CoolBlue's Avatar
CoolBlue CoolBlue is offline Windows 7 64bit Office 2013
Advanced Beginner
 
Join Date: Jun 2014
Location: Australia
Posts: 40
CoolBlue is on a distinguished road
Default Slow "comparison/replace" script

Quote:
Originally Posted by whatsup View Post
On the proof for the release of memory I also agree, though it's more complicated as you showed:
Actually:
If Mem_ReadHex_Words(lng_varPtr, 4) doesn't point anymore to
HexPtr(lng_objPtr, 4)
And
Mem_ReadHex_Words(lng_objPtr, 4) Mem_ReadHex_Words(ObjPtr(Sheet1))
should proof that memory has been released. (But that's just for the record, I think you meant the same)
Yep, thanks for pointing that out, I left out the in my post and have now corrected it.

Quote:
Originally Posted by whatsup View Post
Yes, I was setting it to 4 knowing the value (for objects) has to be in the range of Long. I didn't intend to test anything else with the tool.

Actually I thought it was me who changed your code and left the 4 there

Im building a class module now to encapsulate this stuff to make it more convenient to deploy. I have some problem related to the need to pass the variable/object into the class as a variant type, i need to make sure the original address is available inside the class, so I just need solve that. I guess its got something to do with decoding the Variant Type structure but the Bytecomb site is very helpful on that, so shouldn't be a problem i think...
Reply With Quote