AnsweredAssumed Answered

AW: vrf Add a sheet in Excel with VEE

Question asked by bertram.koelbli on Sep 21, 2005
Latest reply on Sep 21, 2005 by bertram.koelbli
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN"><HTML><HEAD><META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=us-ascii"><TITLE>Add a sheet in Excel with VEE</TITLE><META content="MSHTML 6.00.2900.2722" name=GENERATOR><STYLE>@font-face {     font-family: Tahoma;}@page Section1 {size: 8.5in 11.0in; margin: 1.0in 1.25in 1.0in 1.25in; }P.MsoNormal {     FONT-SIZE: 12pt; MARGIN: 0in 0in 0pt; FONT-FAMILY: "Times New Roman"}LI.MsoNormal {     FONT-SIZE: 12pt; MARGIN: 0in 0in 0pt; FONT-FAMILY: "Times New Roman"}DIV.MsoNormal {     FONT-SIZE: 12pt; MARGIN: 0in 0in 0pt; FONT-FAMILY: "Times New Roman"}A:link {     COLOR: blue; TEXT-DECORATION: underline}SPAN.MsoHyperlink {     COLOR: blue; TEXT-DECORATION: underline}A:visited {     COLOR: #606420; TEXT-DECORATION: underline}SPAN.MsoHyperlinkFollowed {     COLOR: #606420; TEXT-DECORATION: underline}P {     FONT-SIZE: 12pt; MARGIN-LEFT: 0in; MARGIN-RIGHT: 0in; FONT-FAMILY: "Times New Roman"}SPAN.EmailStyle18 {     COLOR: navy; FONT-FAMILY: Arial}DIV.Section1 {     page: Section1}</STYLE></HEAD><BODY lang=EN-US vLink=#606420 link=blue><DIV dir=ltr align=left><SPAN class=555325307-22092005><FONT face=Arial color=#0000ff size=2>Han,</FONT></SPAN></DIV><DIV dir=ltr align=left><SPAN class=555325307-22092005><FONT face=Arial color=#0000ff size=2></FONT></SPAN> </DIV><DIV dir=ltr align=left><SPAN class=555325307-22092005><FONT face=Arial color=#0000ff size=2>I want to insert a new table sheet between sheets g6 and f5 of EXCEL folder zzz.xls. This sheet shall have a format like in master.xlt.</FONT></SPAN></DIV><DIV dir=ltr align=left><SPAN class=555325307-22092005><FONT face=Arial color=#0000ff size=2></FONT></SPAN> </DIV><DIV dir=ltr align=left><SPAN class=555325307-22092005><FONT face=Arial color=#0000ff size=2>Regards</FONT></SPAN></DIV><DIV dir=ltr align=left><SPAN class=555325307-22092005><FONT face=Arial color=#0000ff size=2>Bertram</FONT></SPAN></DIV><BR><DIV class=OutlookMessageHeader lang=de dir=ltr align=left><HR tabIndex=-1><FONT face=Tahoma size=2><B>Von:</B> Tran, Han [mailto:tranh@tycoelectronics.com] <BR><B>Gesendet:</B> Donnerstag, 22. September 2005 00:53<BR><B>An:</B> Koelbli, Bertram (GE02)<BR><B>Betreff:</B> RE: [vrf] Add a sheet in Excel with VEE<BR></FONT><BR></DIV><DIV></DIV><DIV class=Section1><P class=MsoNormal><FONT face=Arial color=navy size=2><SPAN style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: Arial">            Bertram,</SPAN></FONT></P><P class=MsoNormal><FONT face=Arial color=navy size=2><SPAN style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: Arial"></SPAN></FONT> </P><P class=MsoNormal><FONT face=Arial color=navy size=2><SPAN style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: Arial">            I can not run your software because of missing Excel Library.  However, I can not understand your objective.</SPAN></FONT></P><P class=MsoNormal><FONT face=Arial color=navy size=2><SPAN style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: Arial">            Do you want to copy a sheet to another Excel file?</SPAN></FONT></P><P class=MsoNormal><FONT face=Arial color=navy size=2><SPAN style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: Arial">            Do you want to add-in data to an existing sheet?</SPAN></FONT></P><P class=MsoNormal><FONT face=Arial color=navy size=2><SPAN style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: Arial">            Do you need to do this all the time or just one?</SPAN></FONT></P><P class=MsoNormal><FONT face=Arial color=navy size=2><SPAN style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: Arial"></SPAN></FONT> </P><P class=MsoNormal><FONT face=Arial color=navy size=2><SPAN style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: Arial">            Regards,</SPAN></FONT></P><P class=MsoNormal><FONT face=Arial color=navy size=2><SPAN style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: Arial"></SPAN></FONT> </P><P class=MsoNormal><FONT face=Arial color=navy size=2><SPAN style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: Arial">            Han</SPAN></FONT></P><P class=MsoNormal><FONT face=Arial color=navy size=2><SPAN style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: Arial">            </SPAN></FONT></P><P class=MsoNormal><FONT face=Arial color=navy size=2><SPAN style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: Arial"></SPAN></FONT> </P><P class=MsoNormal style="MARGIN-LEFT: 0.5in"><FONT face=Tahoma size=2><SPAN style="FONT-SIZE: 10pt; FONT-FAMILY: Tahoma">-----Original Message-----<BR><B><SPAN style="FONT-WEIGHT: bold">From:</SPAN></B> Koelbli, Bertram (GE02) [mailto:bertram.koelbli@honeywell.com] <BR><B><SPAN style="FONT-WEIGHT: bold">Sent:</SPAN></B> Wednesday, September 21, 2005 7:29 AM<BR><B><SPAN style="FONT-WEIGHT: bold">To:</SPAN></B> VRF<BR><B><SPAN style="FONT-WEIGHT: bold">Subject:</SPAN></B> [vrf] Add a sheet in Excel with VEE</SPAN></FONT></P><P class=MsoNormal style="MARGIN-LEFT: 0.5in"><FONT face="Times New Roman" size=3><SPAN style="FONT-SIZE: 12pt"></SPAN></FONT> </P><P class=MsoNormal style="MARGIN-LEFT: 0.5in"><FONT face="Times New Roman" size=3><SPAN style="FONT-SIZE: 12pt"></SPAN></FONT> </P><P style="MARGIN-LEFT: 0.5in"><FONT face=Arial size=2><SPAN style="FONT-SIZE: 10pt; FONT-FAMILY: Arial">Hello VRF,</SPAN></FONT> </P><P style="MARGIN-LEFT: 0.5in"><FONT face=Arial size=2><SPAN style="FONT-SIZE: 10pt; FONT-FAMILY: Arial">I need to add a new data sheet of type "master.xlt" in an existing EXCEL file "zzz.xls". I wrote the appended program "testexcel.vee" with VEE7.5. But it does not work. It produces an error as in "error.jpg". Can anybody help? </SPAN></FONT></P><P style="MARGIN-LEFT: 0.5in"><FONT face=Arial size=2><SPAN style="FONT-SIZE: 10pt; FONT-FAMILY: Arial">Thanks</SPAN></FONT> <BR><FONT face=Arial size=2><SPAN style="FONT-SIZE: 10pt; FONT-FAMILY: Arial">Bertram</SPAN></FONT> </P><P style="MARGIN-LEFT: 0.5in"><FONT face=Arial color=black size=2><SPAN style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: Arial">||excel.zip>> </SPAN></FONT></P><P class=MsoNormal style="MARGIN-LEFT: 0.5in"><FONT face="Times New Roman" size=3><SPAN style="FONT-SIZE: 12pt"><BR>--- <BR>You are currently subscribed to vrf as: tranh@tycoelectronics.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@agilent.com". <BR>If you need help with the mailing list send a message to "owner-vrf@it.lists.it.agilent.com". <BR>Search the "unofficial vrf archive" at "www.oswegosw.com/vrf_archive/". </SPAN></FONT></P></DIV><BR>---<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@agilent.com".  <BR>If you need help with the mailing list send a message to "owner-vrf@it.lists.it.agilent.com".<BR>Search the "unofficial vrf archive" at "www.oswegosw.com/vrf_archive/".</BODY></HTML>  

Outcomes