AnsweredAssumed Answered

vrf FW: Charting data from Excel

Question asked by VRFuser on Feb 21, 2004
<!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 6.00.2800.1400" 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: purple; TEXT-DECORATION: underline}SPAN.MsoHyperlinkFollowed {     COLOR: purple; TEXT-DECORATION: underline}SPAN.emailstyle17 {     COLOR: windowtext; FONT-FAMILY: Arial}SPAN.emailstyle18 {     COLOR: navy; FONT-FAMILY: Arial}SPAN.EmailStyle19 {     COLOR: navy; FONT-FAMILY: Arial}DIV.Section1 {     page: Section1}</STYLE></HEAD><BODY lang=EN-US vLink=purple link=blue bgColor=#ffffff><DIV><FONT face=Arial size=2>Thanks to everyone for your help the program is working great</FONT></DIV><DIV><FONT face=Arial size=2></FONT> </DIV><DIV><FONT face=Arial size=2>Cecil L Gray</FONT></DIV><BLOCKQUOTE style="PADDING-RIGHT: 0px; PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #000000 2px solid; MARGIN-RIGHT: 0px">  <DIV style="FONT: 10pt arial">----- Original Message ----- </DIV>  <DIV   style="BACKGROUND: #e4e4e4; FONT: 10pt arial; font-color: black"><B>From:</B>   <A title=tranh@tycoelectronics.com   href="mailto:tranh@tycoelectronics.com">Tran, Han</A> </DIV>  <DIV style="FONT: 10pt arial"><B>To:</B> <A title=vrf@agilent.com   href="mailto:vrf@agilent.com">VRF</A> </DIV>  <DIV style="FONT: 10pt arial"><B>Cc:</B> <A title=vrf@agilent.com   href="mailto:'vrf@agilent.com'">'vrf@agilent.com'</A> </DIV>  <DIV style="FONT: 10pt arial"><B>Sent:</B> Thursday, February 19, 2004 11:27   PM</DIV>  <DIV style="FONT: 10pt arial"><B>Subject:</B> [vrf] FW: Charting data from   Excel</DIV>  <DIV><BR></DIV>  <DIV class=Section1>  <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><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> Tran, Han   <BR><B><SPAN style="FONT-WEIGHT: bold">Sent:</SPAN></B> Thursday, February 19,   2004 6:15 PM<BR><B><SPAN style="FONT-WEIGHT: bold">To:</SPAN></B> 'Cecil   Gray'<BR><B><SPAN style="FONT-WEIGHT: bold">Subject:</SPAN></B> RE: [vrf]   Charting data from Excel</SPAN></FONT></P>  <P class=MsoNormal><FONT face="Times New Roman" size=3><SPAN   style="FONT-SIZE: 12pt"></SPAN></FONT> </P>  <P class=MsoNormal><FONT face=Arial color=navy size=2><SPAN   style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: Arial">              Cecil,</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">              It seem like there are two problems with your code.</SPAN></FONT></P>  <P class=MsoNormal><FONT face=Arial color=navy size=2><SPAN   style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: Arial">              First, you need to set the delay longer than 0.5sec...it need about 5 sec or   more depend on your number of channel or thermo-couple</SPAN></FONT></P>  <P class=MsoNormal><FONT face=Arial color=navy size=2><SPAN   style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: Arial">              Selection.  Basically, it did not have time to set the variable like TC1   or TC3 ....you need to delay calling the chart function until   are</SPAN></FONT></P>  <P class=MsoNormal><FONT face=Arial color=navy size=2><SPAN   style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: Arial">              Your TC1 thru 12 are get set a value or it will cause error "can not find   variable"/</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">              Second,  you need to check Task Manager to make sure all Excel running is   kill.  There is a chance that you code did not close it</SPAN></FONT></P>  <P class=MsoNormal><FONT face=Arial color=navy size=2><SPAN   style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: Arial">              Properly and this will cause other error or conflict.</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">              Best 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 Tran</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> Cecil Gray   [mailto:cgray@holmeshq.com] <BR><B><SPAN   style="FONT-WEIGHT: bold">Sent:</SPAN></B> </SPAN></FONT><FONT face=Tahoma   size=2><SPAN style="FONT-SIZE: 10pt; FONT-FAMILY: Tahoma">Wednesday, February   18, 2004</SPAN></FONT><FONT face=Tahoma size=2><SPAN   style="FONT-SIZE: 10pt; FONT-FAMILY: Tahoma"> </SPAN></FONT><FONT face=Tahoma   size=2><SPAN style="FONT-SIZE: 10pt; FONT-FAMILY: Tahoma">5:42   AM</SPAN></FONT><FONT face=Tahoma size=2><SPAN   style="FONT-SIZE: 10pt; FONT-FAMILY: Tahoma"><BR><B><SPAN   style="FONT-WEIGHT: bold">To:</SPAN></B> VRF<BR><B><SPAN   style="FONT-WEIGHT: bold">Subject:</SPAN></B> [vrf] Charting data from   Excel</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=Arial size=2><SPAN   style="FONT-SIZE: 10pt; FONT-FAMILY: Arial">Anyone who can   help:</SPAN></FONT></P>  <P class=MsoNormal style="MARGIN-LEFT: 0.5in"><FONT face=Arial size=2><SPAN   style="FONT-SIZE: 10pt; FONT-FAMILY: Arial">I am getting an error saying   ("can't find TC1") TC1 is the name of the Set value and Get value. The error   is at the Get value which is in the user function with the chart. I tried   delaying the chart but it didn't work. The excel part of the program works   fine but the chat is where the issue is. Sometimes it will work great but if   close the program sad restart it that is when I get the errors. If you need   any other clarification please let me know.</SPAN></FONT></P>  <P class=MsoNormal style="MARGIN-LEFT: 0.5in"><FONT face=Arial size=2><SPAN   style="FONT-SIZE: 10pt; FONT-FAMILY: Arial"></SPAN></FONT> </P>  <P class=MsoNormal style="MARGIN-LEFT: 0.5in"><FONT face=Arial size=2><SPAN   style="FONT-SIZE: 10pt; FONT-FAMILY: Arial"></SPAN></FONT> </P>  <P class=MsoNormal style="MARGIN-LEFT: 0.5in"><FONT face="Times New Roman"   size=3><SPAN style="FONT-SIZE: 12pt">Thank You</SPAN></FONT></P>  <P class=MsoNormal style="MARGIN-LEFT: 0.5in"><FONT face="Times New Roman"   size=3><SPAN style="FONT-SIZE: 12pt">Cecil L. Gray</SPAN></FONT></P>  <P class=MsoNormal style="MARGIN-LEFT: 0.5in"><FONT face="Times New Roman"   size=3><SPAN style="FONT-SIZE: 12pt">Engineering Technician   II</SPAN></FONT></P>  <P class=MsoNormal style="MARGIN-LEFT: 0.5in"><ST1:STREET><ST1:ADDRESS   style="BACKGROUND-POSITION: left bottom; BACKGROUND-IMAGE: url(res://ietag.dll/#34/#1001); BACKGROUND-REPEAT: repeat-x"><FONT   face=Arial size=3><SPAN style="FONT-SIZE: 12pt; FONT-FAMILY: Arial">1 Holmes   Way</SPAN></FONT></ST1:ADDRESS></ST1:STREET></P>  <P class=MsoNormal style="MARGIN-LEFT: 0.5in"><FONT face=Arial size=3><SPAN   style="FONT-SIZE: 12pt; FONT-FAMILY: Arial">Building B</SPAN></FONT></P>  <P class=MsoNormal style="MARGIN-LEFT: 0.5in"><ST1:CITY><ST1:PLACE><FONT   face=Arial size=3><SPAN   style="FONT-SIZE: 12pt; FONT-FAMILY: Arial">Milford</ST1:PLACE></ST1:CITY></SPAN></FONT><FONT   face=Arial><SPAN style="FONT-FAMILY: Arial"> Ma.01757</SPAN></FONT></P>  <P class=MsoNormal style="MARGIN-LEFT: 0.5in"><U><FONT face="Times New Roman"   color=blue size=2><SPAN style="FONT-SIZE: 10pt; COLOR: blue"><A   href="mailto:cgray@holmeshq.com508-422-1497">cgray@holmeshq.com</A></SPAN></FONT></U></P>  <P class=MsoNormal style="MARGIN-LEFT: 0.5in"><U><FONT face="Times New Roman"   color=blue size=3><SPAN style="FONT-SIZE: 12pt; COLOR: blue"><A   href="mailto:cgray@holmeshq.com508-422-1497">508-422-1497</A></SPAN></FONT></U></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">---<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>Send your favorite VEE   example to "VRF-EXAMPLES@agilent.com" for possible inclusion in VEE 7.0!   </SPAN></FONT></P></DIV>---<BR>You are currently subscribed to vrf as:   cecil.gray@verizon.net<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>Send your favorite VEE   example to "VRF-EXAMPLES@agilent.com" for possible inclusion in VEE 7.0! </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@agilent.com".  <BR>If you need help with the mailing list send a message to "owner-vrf@it.lists.it.agilent.com".<BR>Send your favorite VEE example to "VRF-EXAMPLES@agilent.com" for possible inclusion in VEE 7.0!</BODY></HTML>  

Outcomes