Re: Excel automation

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: Michelle (anonymous_at_discussions.microsoft.com)
Date: 02/11/04 

Date: Wed, 11 Feb 2004 09:01:12 -0800

Thanks Tom

I don't think I have any unqualified references in the way of your example as any excel objects i use are preceded by xlapp or wbroster(which was created using xlapp). However, I am not entirely sure that I have cleared all references to all objects. Is there an easy way to see the value of the variables just before (say at the last line of code) code stops running. I have many excel object variables of all different scopes. I have tried using watches but obviously proc level variables are not defined in context at the last line of my code if they are in a different procedure.

I am wondering if the only way is to add watches to all variables and step through code line by line (it is very long) and check that all variables are set to nothing before they go out of scope. Is this what you would suggest. Or perhaps i could step through code and use locals window?

Just one more question, would passing these objects as args to other subs/functions create another reference to them?

Thanks for your help
Michelle

Relevant Pages

  • Re: Python **kwargs ?
    ... johnny wrote: ... passing by reference? ... args: ...
    (comp.lang.python)
  • Re: pointer syntax
    ... > really passing a reference (which is like an old-school pointer, ... > a copy of the primitive's value and passing that. ... build them yourself with pointers. ... mean a var parameter, write a var parameter. ...
    (comp.lang.pascal.delphi.misc)
  • Re: Passing by reference
    ... It depends upon the reason one is passing the reference. ... instantiate all relationships via a constructor so there will always be ... I naturally think of 'getter' methods as 'knowledge ...
    (comp.object)
  • Re: Using ref
    ... the address of a variable that contains a reference to an object, ... the C version is passing the address of a variable that contains the   ... Inasmuch as the specification is unambiguous, there is a single truth. ... Every time he states the incorrect view, I will feel compelled to correct his incorrect statements. ...
    (microsoft.public.dotnet.languages.csharp)
  • RE: Observation on object references
    ... Wouldn't it be nice if we could declare a reference type in C# that would ... You then call processs and pass in the args variable, ... public class Handler2: HandlerBase ...
    (microsoft.public.dotnet.languages.csharp)