AnsweredAssumed Answered

vrf Problem with Excel

Question asked by gregwale on Feb 5, 2004
Richard,

I think I have this problem of Excel launching with invisible workbook
totally figured out at long last!

If I add a VEE delete library object for Vxl after the QuitVxl object, Excel
can be launched by double clicking an xls OK. Or you can turn off VEE
default preferences / debug features and then you don't need the delete
library object. (VEE's debugger hangs on to an Excel reference for the
purposes of line probe, etc.) I was able to reliably make Excel launch
correctly with workbook always visible according to this approach on Win2k.


Regards,
Greg

Better Test Reports Faster with VEE, Vxl, and Excel
www.passtechnologies.com


> -----Original Message-----
> From: Richard Kleinhenz [mailto:scubaman@us.ibm.com]
> Sent: Thursday, February 05, 2004 3:56 PM
> To: g.wale@comcast.net
> Subject: RE: [vrf] RE: Problem with Excel
>
>
>
>
>
> Disabling the debug feature makes no sense to me, the way I work, so I did
> not even try it.  It's just as easy and as many mouse clicks to kill the
> process in task manager if I keep task manager open.  And yes, if I exit
> Vee altogether, the Excel process disappears, and I can double-click
> normally.  Whatever Richard does - it works.  I just won't be able to even
> take a closer look till next week sometime.
> --
> Regards,
> Rich
> ===================
> Richard Kleinhenz
> Wafer Engineering
> 845-892-2617
> scubaman@us.ibm.com
> ===================
>
>
>
>              g.wale@comcast.ne
>              t
>                                                                         To
>              02/05/2004 04:59          Richard
>              PM                        Kleinhenz/Fishkill/IBM@IBMUS
>                                                                         cc
>
>                                                                    Subject
>                                        RE: [vrf] RE: Problem with Excel
>
>
>
>
>
>
>
>
>
>
> Richard,
>
> Interesting that his program allows you to double click an xls and see it
> ok. I will take a look at it later. But did you try all those steps I sent
> incl Disable Debug Features (or exiting VEE) and still have the problem?
>
> Greg
> >
> >
> >
> >
> > I see that now.  However...  Seems like Richard Walker is able to close
> > down Excel all the way.  He says he sent you the code in October, after
> the
> > NJ Vee days where I also was.  I can send it to you again.  I don't know
> > how general his solution is, and whether it can be implemented inside
> vxl.
> > All I know is that in his example, there is no lingering instance of
> excel,
> > and I can open files by double-clicking.
> > (See attached file: temp_excel.zip)
> > --
> > Regards,
> > Rich
> > ===================
> > Richard Kleinhenz
> > Wafer Engineering
> > 845-892-2617
> > scubaman@us.ibm.com
> > ===================
> >
> >
> >
>
> >              "Greg Wale"
>
> >              <gregwale@passtec
>
> >              hnologies.com>
> To
> >                                        Richard
>
> >              02/05/2004 11:53          Kleinhenz/Fishkill/IBM@IBMUS
>
> >              AM
> cc
> >
>
> >
> Subject
> >              Please respond to         RE: [vrf] RE: Problem with Excel
>
> >                  gregwale
>
> >
>
> >
>
> >
>
> >
>
> >
>
> >
> >
> >
> >
> > Rich,
> >
> > There is a known defect with Excel that fits what you describe. If you
> > double-click an xls like from File Manager or Windows Explorer like you
> > say,
> > Excel appears as only a partial window and the xls is not visible
> (weirdly
> > transparent).
> >
> > > -----Original Message-----
> > > From: Richard Kleinhenz [mailto:scubaman@us.ibm.com]
> > > Sent: Thursday, February 05, 2004 9:41 AM
> > > To: gregwale@passtechnologies.com
> > > Subject: RE: [vrf] RE: Problem with Excel
> > >
> > >
> > >
> > >
> > >
> > > Hi Greg,
> > > actually, it seems to me that that instance of Excel that's still
> running
> > > *IS* trouble.  Say I run an applicatio, use quitvxl, and delete the
> vxl
> > > library,, and end the program.  Now that Excel is still running.  I go
> to
> > > file manager, and couble-click on any .xls - it will *NOT* open for
> me.
> > > Does it open for you?  I use win2k, not sure it matters.  So adding a
> > > delete libarary object does not seem to have an effect.
> > >
> > > I will attempt to attach some files someone sent me.  Does not involve
> > > vxl,
> > > but is an elaborate method for killing excel, apparently.  I have not
> had
> > > time to analyze what he is doing.  But it DOES close that remaining
> > > instance of Excel.  Since he attempted to post this in vrf I think
> it's
> > OK
> > > to pass on.  Actually, let me ask him before I step on someone's toes
> -
> > > I'm
> > > sure it'll be OK.
> > > --
> > > Regards,
> > > Rich
> > > ===================
> > > Richard Kleinhenz
> > > Wafer Engineering
> > > 845-892-2617
> > > scubaman@us.ibm.com
> > > ===================
> > >
> > >
> > >
> > >              "Greg Wale"
> > >              <gregwale@passtec
> > >              hnologies.com>
> > To
> > >                                        Richard
> > >              02/05/2004 11:28          Kleinhenz/Fishkill/IBM@IBMUS
> > >              AM
> > cc
> > >
> > >
> > Subject
> > >              Please respond to         RE: [vrf] RE: Problem with
> Excel
> > >                  gregwale
> > >
> > >
> > >
> > >
> > >
> > >
> > >
> > >
> > >
> > > Rich,
> > >
> > > After running and stopping a VEE-Vxl program, it is normal-ok-behavior
> to
> > > see one instance of Excel under Windows task manager, and doesn't hurt
> > > anything. What is trouble, is if you re-run and >multiple< instances
> of
> > > Excel accumulate, but this never happens with Vxl -by design.
> > >
> > > To totally get rid of Excel references from VEE Ive observed that with
> > Vxl
> > > you must do this:
> > >
> > > 0. Stop editing anything in Excel if applicable.
> > > 1. Execute a QuitVxl (this deletes the xl global)
> > > 2. Execute a delete library object for Vxl
> > > 3. Turn off under File / Default Preferences VEE's debug features,
> > > although
> > > this is getting to be a decreasing returns thing here and I don't
> > > recommend
> > > this except as a test.
> > > 4. Alternative to 3: Exiting VEE will also remove the final instance
> of
> > > Excel.
> > >
> > > If you have Excel in edit mode for any cell or who knows what else
> like
> > > charts or graphic objects, 1) wont work, and no ActveX will work. Even
> > > some
> > > toolbar add-ins wont work and go grey when in edit mode.
> > >
> > > Having that last instance of Excel still running shouldn't be a
> problem
> > as
> > > far as I can tell, and there is no need to get rid of it using 3) or
> 4).
> > > If
> > > there are problems with Excel, then something else is going on.
> > >
> > > I may want to add the delete library object to my QuitVxl call. Can
> you
> > > help
> > > me with info as to whether that matters or not? I don't think so, but
> the
> > > more info the better.
> > >
> > > Hope this helps,
> > > Greg
> > >
> > >
> > >
> > > > -----Original Message-----
> > > > From: Richard Kleinhenz [mailto:scubaman@us.ibm.com]
> > > > Sent: Wednesday, February 04, 2004 11:19 AM
> > > > To: Greg Wale; vrf@it.lists.it.agilent.com
> > > > Subject: Re: [vrf] RE: Problem with Excel
> > > >
> > > >
> > > >
> > > >
> > > >
> > > > I do have a QuitVxl object at the end.  Delete library object for
> which
> > > > library?  vxl or xl?  Either one still leaves the Excel process
> > running.
> > > > --
> > > > Regards,
> > > > Rich
> > > > ===================
> > > > Richard Kleinhenz
> > > > Wafer Engineering
> > > > 845-892-2617
> > > > scubaman@us.ibm.com
> > > > ===================
> > > >
> > > >
> > > >
> > > >              "Greg Wale"
> > > >              <gregwale@passtec
> > > >              hnologies.com>
> > > To
> > > >                                        VRF <vrf@agilent.com>
> > > >              02/04/2004 11:06
> > > cc
> > > >              AM                        <vrf@agilent.com>
> > > >
> > > Subject
> > > >                                        [vrf] RE: Problem with Excel
> > > >              Please respond to
> > > >                 "Greg Wale"
> > > >
> > > >
> > > >
> > > >
> > > >
> > > >
> > > >
> > > >
> > > > Hi Rich,
> > > >
> > > > Do you have the QuitVxl object at the end of your Excel code? If you
> > > have
> > > > that, and optionally add a delete library object after that, there
> > > should
> > > > be
> > > > no reason to use kill process. The only reference left to Excel from
> > VEE
> > > > would be the debugger reference (for line probing) and that's no
> reason
> > > to
> > > > use kill process as far as I've found.
> > > >
> > > > But watch out as an interactive user -if you have Excel in edit mode
> > (by
> > > > editing a cell) - it will not respond to any ActiveX commands from
> VEE
> > > or
> > > > VBA.
> > > >
> > > > Regards,
> > > > Greg
> > > >
> > >
> > >
> > >
> > >
> >
> >
> >
>




---
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".
Send your favorite VEE example to "VRF-EXAMPLES@agilent.com" for possible inclusion in VEE 7.0!

Outcomes