AnsweredAssumed Answered

vrf Fw: EXCEL will not close

Question asked by VRFuser on Jun 16, 2003
Hello Peter and Andy

It's worth pointing out that when using variables of type "Object Reference"
(eg. 'appl'), for as long as the variable is set, the related object will
exist (in most normal cases).  In addition to the "Quit" method, the
variable must be deleted to release the referenced object.

We avoid using data input/output pins and connecting lines for object
references for just that reason (to ensure that no object references are
remaining).  We always use declared or set variables for object references,
which we delete/reset when not required.

Andrew F
Genesys IBS


----- Original Message -----
From: STREET,ANDY (A-England,ex2) <andy_street@agilent.com>
To: VEE vrf <vrf@it.lists.it.agilent.com>
Sent: Tuesday, June 17, 2003 1:12 PM
Subject: [vrf] RE: EXCEL will not close


> Hello Peter,
>
> The perennial Excel issue....  There are some comments in the on-line help
with regard to this issue (in VEE 6 onwards).  In order to get Excel to die
you will need to:
>
> 1) Call the .quit() method
> 2) Delete variables that are objects to Excel
> 3) Ensure that the debug features are disabled
>
> Note you need to do ALL 3 steps.
>
> The last one is a pain when you are developing.  What I tend to do is have
a process killer to nail unwanted copies of Excel when I am developing.
When the code is ready for release, then implement steps 1-3.
>
> Hope this helps
>
> Andy
>
>
> -----Original Message-----
> From: ADN at PCMESS [mailto:adn_at_pcmess@vr-web.de]
> Sent: 17 June 2003 13:00
> To: VEE vrf
> Subject: [vrf] EXCEL will not close
>
>
> Hi,
> I encounter most always following problem using ActiveX on EXCEL (97 and
2000):
>
> After running the program under VEE EXCEL will not close, which is done,
when I use the
> *.vxe - version under VEE-runtime.
>
> As it is somewhat boaring, when I try different settings of EXCEL from VEE
to always use the
> ctrl^alt^del-business to close down EXCEL or, what is even worse, to
always convert to *.vxe,
> I would be very glad to get advice.
>
> I'm using [appl.Quit();] to close EXCEL,where appl is Application.
>
> Peter
> ---
> You are currently subscribed to vrf as: andy_street@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@it.lists.it.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: 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@it.lists.it.agilent.com".
> If you need help with the mailing list send a message to
"mailto:owner-vrf@it.lists.it.agilent.com.


---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.489 / Virus Database: 288 - Release Date: 10/06/03



---
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@it.lists.it.agilent.com". 
If you need help with the mailing list send a message to "owner-vrf@it.lists.it.agilent.com".

Outcomes