Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #10  
Old 06-16-2014, 07:15 PM
CoolBlue's Avatar
CoolBlue CoolBlue is offline Slow "comparison/replace" script Windows 7 64bit Slow "comparison/replace" script Office 2013
Advanced Beginner
 
Join Date: Jun 2014
Location: Australia
Posts: 40
CoolBlue is on a distinguished road
Default

Well... I think its strange to put some code in, just in case there is a bug in the scripting engine.
Methinks you worry too much?
Well... Mebelieves is probably more apropriate.
I'm always happy to learn, but I am cautious of mythology...
I didn't see any authoritative references offered above in support of this practice.
I can find plenty refuting it and even more who are confused about it...
And there are plenty of structures where it will do nothing at all because there are references to the object elsewhere.

Referring to post #7 there are two reasons given for the practice. Regarding the first, see my opening statement. Regarding the second, it is patently untrue I'm afraid: Custom Class Objects and Objects that are instantiated with a New statement do not need to be explicitly deallocated with a Set to Nothing line. They are managed in the same way as any other object again, by counting referrences. And, depending on their archiatecture, it could give the misleading impression that they have been released when they have not.

So, to be honest, I don't accept either as a valid reason.
Reply With Quote
 



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
Slow "comparison/replace" script 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
Slow "comparison/replace" script 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

Other Forums: Access Forums

All times are GMT -7. The time now is 04:19 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft