AnsweredAssumed Answered

vrf VEE, Excel and File Associations - VEE bug?

Question asked by reiner.schlieker on Dec 17, 2002
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN"><HTML><HEAD><META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=iso-8859-1"><META content="MSHTML 5.50.4916.2300" name=GENERATOR><STYLE></STYLE></HEAD><BODY bgColor=#ffffff><DIV><SPAN class=974065213-18122002><FONT face=Arial color=#0000ff size=2>I'vejust started diving into the VEE-Excel world as well, and I'm seeing the samebehaviour under Win2k, except it doesn't crash.  Even when VEE kills Excel,if the VEE program is still opened, then, as you describe, double-clicking on anexcel file starts Excel but doesn't show the file.  I'll have to try thedelete library suggestion.</FONT></SPAN></DIV><DIV><SPAN class=974065213-18122002><FONT face=Arial color=#0000ffsize=2></FONT></SPAN> </DIV><DIV><SPAN class=974065213-18122002><FONT face=Arial color=#0000ff size=2>BTW,since we're talking about Excel again:  I want to log data to Excel, andthe program should look for an existing log if it exists, or load a templatefile, and then save it under a new name if it doesn't.  My problem is if Iload an existing file, it loads it as a read-only, and then I can't save itunder the same name (excel prompts me, which is undesirable)  I can't seemto force it to save without question - what am I doingwrong?</FONT></SPAN></DIV><DIV><SPAN class=974065213-18122002><FONT face=Arial color=#0000ffsize=2></FONT></SPAN> </DIV><DIV><SPAN class=974065213-18122002><FONT face=Arial color=#0000ffsize=2>Thanks,</FONT></SPAN></DIV><DIV><SPAN class=974065213-18122002><FONT face=Arial color=#0000ffsize=2></FONT></SPAN> </DIV><DIV><SPAN class=974065213-18122002><FONT face=Arial color=#0000ffsize=2>Reiner</FONT></SPAN></DIV><BLOCKQUOTE>  <DIV class=OutlookMessageHeader dir=ltr align=left><FONT face=Tahoma  size=2>-----Original Message-----<BR><B>From:</B> Pickles, Warren  [mailto:Warren.Pickles@tycoelectronics.com]<BR><B>Sent:</B> Wednesday,  December 18, 2002 3:41 AM<BR><B>To:</B> VEE vrf<BR><B>Subject:</B> [vrf] RE:  VEE, Excel and File Associations - VEE bug?<BR><BR></FONT></DIV>  <DIV> </DIV>  <DIV><FONT face=Arial color=#0000ff size=2><SPAN  class=786533308-18122002>George,</SPAN></FONT></DIV>  <DIV><FONT face=Arial color=#0000ff size=2><SPAN  class=786533308-18122002></SPAN></FONT> </DIV>  <DIV><FONT face=Arial color=#0000ff size=2><SPAN class=786533308-18122002>I  just tried your example on windows NT.  It looks like VEE doesn't close  excel properly, because excel.exe process is still there in the NT task  manager after the program finishes.  If you kill excel.exe using the "End  Process" button, then you can open excel files OK.  Also if you close the  VEE program with eg File/New, the excel.exe process disappears and excel files  open OK.</SPAN></FONT></DIV>  <DIV><FONT face=Arial color=#0000ff size=2><SPAN  class=786533308-18122002></SPAN></FONT> </DIV>  <DIV><FONT face=Arial color=#0000ff size=2><SPAN class=786533308-18122002>I  got issues like this a few months ago when I first started to use excel files  in my VEE programs.  My workaround is to put all code that talks to Excel  in a single VEE library.  Then the main program imports this library -  and deletes it when done.  That seems to kill the Excel.exe  process.</SPAN></FONT></DIV>  <DIV><FONT face=Arial color=#0000ff size=2><SPAN  class=786533308-18122002></SPAN></FONT> </DIV>  <DIV><FONT face=Arial color=#0000ff size=2><SPAN class=786533308-18122002>I  seem to remember similar problems being discussed here before, but I don't  remember if anyone got to the bottom of it.</SPAN></FONT></DIV>  <DIV><FONT face=Arial color=#0000ff size=2><SPAN  class=786533308-18122002></SPAN></FONT> </DIV>  <DIV><FONT face=Arial color=#0000ff size=2><SPAN  class=786533308-18122002>Warren Pickles</SPAN></FONT></DIV>  <DIV><FONT face=Arial color=#0000ff size=2><SPAN  class=786533308-18122002></SPAN></FONT> </DIV>  <BLOCKQUOTE style="MARGIN-RIGHT: 0px">    <DIV class=OutlookMessageHeader dir=ltr align=left><FONT face=Tahoma    size=2>-----Original Message-----<BR><B>From:</B> George Tyrrell    [mailto:tdllc01@earthlink.net]<BR><B>Sent:</B> 18 December 2002    05:31<BR><B>To:</B> VEE vrf<BR><B>Subject:</B> [vrf] VEE, Excel and File    Associations - VEE bug?<BR><BR></DIV></FONT>    <DIV><FONT face=Arial size=2><FONT face="Times New Roman" size=3>Hello VRF    users,<BR><BR>The attached program is based upon an example in Bob Helsel's    VEE<BR>programming manual for creating a spreadsheet and then saving the    file.<BR><BR>This file association problem exists in VEE 5.x, 6.0, Win98,    WinNT, Win2K<BR>as tested.  Haven't tested with XP.<BR><BR>Running the    attached program will create an Excel file as the    program<BR>directs.<BR><BR>While the VEE application is still active,    double-clicking on that file (or<BR>any other Excel file in the computer)    will cause a partial load of the file.<BR>Many times it will cause an OS    crash in Win98 resulting in data loss and<BR>requiring a    reboot.<BR><BR>While the VEE application is still active, opening Excel from    the Start menu<BR>then opening the Excel file created works without a    problem.<BR><BR>Closing the VEE application will restore the associations as    they were<BR>before the file was created through VEE.<BR><BR>The    associations for Access still work during this event, so the    effect<BR>appears to be limited to Excel.  However, I suspect that    opening an Access<BR>application through VEE may cause a similar problem    with Access.<BR><BR>During the event, the file may be opened by another    computer (with a<BR>double-click) across the network without a    problem.<BR><BR>Does anyone know how to cause VEE to release the Excel file    association, or<BR>is this an actual bug?<BR><BR>Thanks,<BR>George    Tyrrell<BR><BR>TestDynamics LLC<BR>Thornton,  CO</FONT><BR></FONT></DIV></BLOCKQUOTE>---<BR>You are currently subscribed to  vrf as: reiner.schlieker@siemens.com<BR>To subscribe send a blank email to  "join-vrf@it.lists.it.agilent.com".<BR>To unsubscribe send a blank email to  "leave-vrf@it.lists.it.agilent.com".<BR>To send messages to this mailing list,  email "vrf@it.lists.it.agilent.com". <BR>If you need help with the mailing  list send a message to "owner-vrf@it.lists.it.agilent.com".</BLOCKQUOTE>---<BR>You are currently subscribed to vrf as: rsb@soco.agilent.com<BR>To subscribe send a blank email to "join-vrf@it.lists.it.agilent.com".<BR>To unsubscribe send a blank email to "leave-vrf@it.lists.it.agilent.com".<BR>To send messages to this mailing list,  email "vrf@it.lists.it.agilent.com".  <BR>If you need help with the mailing list send a message to "owner-vrf@it.lists.it.agilent.com".</BODY></HTML>  

Outcomes