Quote:
Originally Posted by whatsup
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
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...
06-24-2014, 07:42 PM
Slow "comparison/replace" script
Similar Threads
replace data from variable with "sub and super script" from excel to word by vba
Windows 7 64bit 
Office 2013
Threaded Mode