AnsweredAssumed Answered

vrf Excel close issue

Question asked by VRFuser on Aug 28, 2006

Like • Show 0 Likes0
Comment • 3

> Any solution for this?

Delete all variables that have held any references to Excel objects. Any references held on wires will also keep Excel around. Turn off debugging features to eliminate holding these references.
-SHAWN-

---
To subscribe please send an email to: "vrf-request@lists.it.agilent.com" with the word subscribe in the message body.
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".
Search the "unofficial vrf archive" at "www.oswegosw.com/vrf_archive/".

No one else has this question

Outcomes

3 Replies

VRFuser Aug 28, 2006 6:11 AM
Mark Correct
Correct Answer
> Any solution for this?

Delete all variables that have held any references to Excel objects. Any
references held on wires will also keep Excel around. Turn off debugging
features to eliminate holding these references.
-SHAWN-

---
You are currently subscribed to vrf as: rsb@soco.agilent.com
To subscribe please send an email to: "vrf-request@lists.it.agilent.com" with the word subscribe in the message body.
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".
Search the "unofficial vrf archive" at "www.oswegosw.com/vrf_archive/".
Like • Show 0 Likes0
Actions
VRFuser Aug 28, 2006 7:05 PM
Mark Correct
Correct Answer

Hi,

I close the excel workbook by using following expression in VEE.

App.DisplayAlerts = False;
App.Workbooks.Close();
App.Quit();

But after the the excel application was close by the program, i just couldn't open any excel file by double click them which is the normal way. Only after i totally quit the program developed with VEE, i can then open the excel file in normal way again.
It seems that the excel instance used to open excel application by VEE is still not released yet.
Any solution for this?

Rgs,

James

--- To subscribe please send an email to: "vrf-request@lists.it.agilent.com" with the word subscribe in the message body. 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". Search the "unofficial vrf archive" at "www.oswegosw.com/vrf_archive/".
Like • Show 0 Likes0
Actions
yjames_1 Aug 28, 2006 7:08 PM
Mark Correct
Correct Answer

Hi,

I close the excel workbook by usingfollowing expression in VEE. 

App.DisplayAlerts = False;
App.Workbooks.Close();
App.Quit();

But after the the excel applicationwas close by the program, i just couldn't open any excel file by doubleclick them which is the normal way. Only after i totally quit the programdeveloped with VEE, i can then open the excel file in normal way again.
It seems that the excel instance usedto open excel application by VEE is still not released yet. 
Any solution for this?

Rgs,

James

---You are currently subscribed to vrf as: rsb@soco.agilent.comTo subscribe please send an email to: "vrf-request@lists.it.agilent.com" with the word subscribe in the message body.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".Search the "unofficial vrf archive" at "www.oswegosw.com/vrf_archive/".
Like • Show 0 Likes0
Actions

vrf Excel close issue

Outcomes

Related Content

Recommended Content