Slow "comparison/replace" script

BobBridges · #1 06-15-2014, 09:20 PM

I think you're saying that if I don't free an object manually, there are circumstances where it might not be freed by the VBA editor as the macro comes to an end. I don't think I ever knew that (or if I did, I forgot). That does make a difference, especially because I tend to leave my laptop on for a week or three at a time and Excel is unlikely to be closed at any time during that period. Run macros again and again, and this could get to be a problem.

Well, I don't know that I'll change my habits overnight. But at least I'm sure to be suspicious if things slow down suddenly, in the near future; I may discover that I'm well advised to do the same as you.

whatsup · #2 06-18-2014, 08:12 PM

Bob, I forgot

Quote:

Originally Posted by BobBridges

...That does make a difference, especially because I tend to leave my laptop on for a week or three at a time and Excel is unlikely to be closed at any time during that period...

I'm quite curious about the results you get in respect of memory allocation when trying the tool CoolBlue provided (DictionarySearch).
Leaving excel for long periods open in my opinion will result in any case that things slow down. I would expect that memory allocation after at least one day equals the limit. But I can't tell by experience, because usually I close excel at least every hour, unless it's doing calculations, but than memory is used to the limit.

whatsup · #3 06-18-2014, 08:38 PM

Interesting:
Features: switch Set To Nothing = False, switch Throw Error = True

Code:

23:25:33:0697 Call RangeCompare2: Don't Set to Nothing:     WorkingSetSize  60.395.520  ( Reference )
23:25:33:0707 Start Timer:                 t = 0.000 sec:   WorkingSetSize  60.403.712  ( 8.192 )
23:25:33:0717 arrCompare Loaded:           t = 0.008 sec:   WorkingSetSize  61.366.272  ( 970.752 )
23:25:33:0747 objDic Loaded:                                WorkingSetSize  61.693.952  ( 1.298.432 )
 ERROR: 450: Wrong number of arguments or invalid property assignment 
23:25:33:0747 after End Sub:                                WorkingSetSize  60.719.104  ( 323.584 )

The difference between Start and End (323.584) remains out of 40 runs 30 times the same, equals once, and for the rest it differs just slightly +/-
What can we make of this?

CoolBlue, I enjoy playing with your tool

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Wierd "script code" in a downloaded .doc file	CNBarnes	Word	2	10-18-2012 02:07 AM
replace data from variable with "sub and super script" from excel to word by vba	krishnaoptif	Word VBA	9	06-22-2012 05:08 AM
How to choose a "List" for certain "Heading" from "Modify" tool?	Jamal NUMAN	Word	2	07-03-2011 03:11 AM
Rules and Alerts: "run a script"?	discountvc	Outlook	0	06-15-2010 07:36 AM
An "error has occurred in the script on this page"	decann	Outlook	8	09-03-2009 08:54 AM