AnsweredAssumed Answered

AW: vrf Add a sheet in Excel with VEE- Vee7.5

Question asked by bertram.koelbli on Nov 20, 2005
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN"><HTML><HEAD><META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=iso-8859-1"><TITLE>Add a sheet in Excel with VEE</TITLE><META content="MSHTML 6.00.2900.2769" name=GENERATOR><STYLE>@font-face {     font-family: MS Mincho;}@font-face {     font-family: Tahoma;}@font-face {     font-family: @MS Mincho;}@page Section1 {size: 595.3pt 841.9pt; margin: 70.85pt 70.85pt 2.0cm 70.85pt; }P.MsoNormal {     FONT-SIZE: 12pt; MARGIN: 0cm 0cm 0pt; FONT-FAMILY: "Times New Roman"}LI.MsoNormal {     FONT-SIZE: 12pt; MARGIN: 0cm 0cm 0pt; FONT-FAMILY: "Times New Roman"}DIV.MsoNormal {     FONT-SIZE: 12pt; MARGIN: 0cm 0cm 0pt; FONT-FAMILY: "Times New Roman"}A:link {     COLOR: blue; TEXT-DECORATION: underline}SPAN.MsoHyperlink {     COLOR: blue; TEXT-DECORATION: underline}A:visited {     COLOR: purple; TEXT-DECORATION: underline}SPAN.MsoHyperlinkFollowed {     COLOR: purple; TEXT-DECORATION: underline}P {     FONT-SIZE: 12pt; MARGIN-LEFT: 0cm; MARGIN-RIGHT: 0cm; FONT-FAMILY: "Times New Roman"}SPAN.EmailFormatvorlage18 {     COLOR: navy; FONT-FAMILY: Arial}DIV.Section1 {     page: Section1}</STYLE></HEAD><BODY lang=DE vLink=purple link=blue><DIV dir=ltr align=left><SPAN class=017493616-21112005><FONT face=Arial color=#0000ff size=2>Thank you very much, Detlef.</FONT></SPAN></DIV><DIV dir=ltr align=left><SPAN class=017493616-21112005><FONT face=Arial color=#0000ff size=2></FONT></SPAN> </DIV><DIV dir=ltr align=left><SPAN class=017493616-21112005><FONT face=Arial color=#0000ff size=2>I never expected a working solution or even a response after this long period of time. Actually I could not solve this problem for myself, because I never learned this Visual Basic and Active X stuff. So I gave up after a little while and created my Excel folder in advance and then accessed it with the VEE 7.5 Excel Tools.</FONT></SPAN></DIV><DIV dir=ltr align=left><SPAN class=017493616-21112005><FONT face=Arial color=#0000ff size=2></FONT></SPAN> </DIV><DIV dir=ltr align=left><SPAN class=017493616-21112005><FONT face=Arial color=#0000ff size=2>But your solution works well and is exactly what I need! </FONT></SPAN></DIV><DIV dir=ltr align=left><SPAN class=017493616-21112005><FONT face=Arial color=#0000ff size=2></FONT></SPAN> </DIV><DIV dir=ltr align=left><SPAN class=017493616-21112005><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> Baranski, Detlef [mailto:Detlef.Baranski@pilkington.de] <BR><B>Gesendet:</B> Donnerstag, 17. November 2005 16:57<BR><B>An:</B> VRF<BR><B>Betreff:</B> AW: [vrf] Add a sheet in Excel with VEE- Vee7.5<BR></FONT><BR></DIV><DIV></DIV><DIV class=Section1><P class=MsoNormal><FONT face=Arial color=navy size=2><SPAN lang=EN-GB style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: Arial"> A little bit late, but here is one possible solution for you </SPAN></FONT></P><P class=MsoNormal><FONT face=Arial color=navy size=2><SPAN lang=EN-GB style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: Arial">Everything can be done smaller in just one formularbox for sure ...</SPAN></FONT></P><P class=MsoNormal><FONT face=Arial color=navy size=2><SPAN lang=EN-GB style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: Arial"></SPAN></FONT> </P><P class=MsoNormal><FONT face=Arial color=navy size=2><SPAN lang=EN-GB style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: Arial">detlef</SPAN></FONT></P><P class=MsoNormal><FONT face=Arial color=navy size=2><SPAN lang=EN-GB style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: Arial"></SPAN></FONT> </P><P class=MsoNormal style="MARGIN-LEFT: 35.4pt"><FONT face=Tahoma size=2><SPAN style="FONT-SIZE: 10pt; FONT-FAMILY: Tahoma">-----Ursprngliche Nachricht-----<BR><B><SPAN style="FONT-WEIGHT: bold">Von:</SPAN></B> Koelbli, Bertram (GE02) [mailto:bertram.koelbli@honeywell.com] <BR><B><SPAN style="FONT-WEIGHT: bold">Gesendet:</SPAN></B> Mittwoch, 21. September 2005 16:29<BR><B><SPAN style="FONT-WEIGHT: bold">An:</SPAN></B> VRF<BR><B><SPAN style="FONT-WEIGHT: bold">Betreff:</SPAN></B> [vrf] Add a sheet in Excel with VEE</SPAN></FONT></P><P class=MsoNormal style="MARGIN-LEFT: 35.4pt"><FONT face="Times New Roman" size=3><SPAN style="FONT-SIZE: 12pt"></SPAN></FONT> </P><P class=MsoNormal style="MARGIN-LEFT: 35.4pt"><FONT face="Times New Roman" size=3><SPAN style="FONT-SIZE: 12pt"></SPAN></FONT> </P><P style="MARGIN-LEFT: 35.4pt"><FONT face=Arial size=2><SPAN style="FONT-SIZE: 10pt; FONT-FAMILY: Arial">Hello VRF,</SPAN></FONT> </P><P style="MARGIN-LEFT: 35.4pt"><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: 35.4pt"><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: 35.4pt"><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: 35.4pt"><FONT face="Times New Roman" size=3><SPAN style="FONT-SIZE: 12pt"><BR>--- <BR>You are currently subscribed to vrf as: Detlef.Baranski@pilkington.de <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: bertram.koelbli@honeywell.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/". <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