AnsweredAssumed Answered

vrf VEE and Excel problem

Question asked by VRFuser on Nov 26, 2003
Hello Keevan and all

If you turn off the debug features you will loose some useful functionality
of VEE.

When the Quit method is called on Excel, Excel tries to close, but if there
are object references in your program (hanging on data input/output pins or
variables), these references will not allow objects to free itself,
including Excel objects and sub objects (i.e. Book, Selection).

To allow Excel to close do not allow object references to be put onto Data
input/output pins.  Just use variables instead.  Delete the variables to
free the object reference.  Excel should close normally.

I've tried this on VEE 6.02 and it works ok.

Regards

Andrew F
Genesys IBS

----- Original Message -----
From: "Simmonds Keevan W IHMD" <SimmondsKW@ih.navy.mil>
To: "VRF" <vrf@agilent.com>
Sent: Tuesday, November 25, 2003 2:31 PM
Subject: [vrf] VEE and Excel problem


> Whenever I run an ActiveXAutomation program referencing Excel2000(9.0), I
> cannot open any excel programs until I shut down VEE.  Has anyone else
> experienced this?  I have tried explicitly closing Excel, but that does
not
> seem to solve the problem.
>
> Keevan Simmonds
> Electronics Engineer
> Test and Evaluation Dept.
> NSWC IHMD
> P: (301) 744-4871
>
> ---
> You are currently subscribed to vrf as: AndrewF@genesysibs.com
> To subscribe send a blank email to "join-vrf@it.lists.it.agilent.com".
> To unsubscribe send a blank email to "leave-vrf@it.lists.it.agilent.com".
> To send messages to this mailing list,  email "vrf@agilent.com".
> If you need help with the mailing list send a message to
"owner-vrf@it.lists.it.agilent.com".


---
You are currently subscribed to vrf as: rsb@soco.agilent.com
To subscribe send a blank email to "join-vrf@it.lists.it.agilent.com".
To unsubscribe send a blank email to "leave-vrf@it.lists.it.agilent.com".
To send messages to this mailing list,  email "vrf@agilent.com". 
If you need help with the mailing list send a message to "owner-vrf@it.lists.it.agilent.com".

Outcomes