AnsweredAssumed Answered

vrf Tables in Excel

Question asked by VRFuser on Nov 7, 2004
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN"><html><head><META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=us-ascii"><meta name=Generator content="Microsoft Word 10 (filtered)"><style><!-- /* Style Definitions */ p.MsoNormal, li.MsoNormal, div.MsoNormal     {margin:0in;     margin-bottom:.0001pt;     font-size:12.0pt;     font-family:"Times New Roman";}a:link, span.MsoHyperlink     {color:blue;     text-decoration:underline;}a:visited, span.MsoHyperlinkFollowed     {color:blue;     text-decoration:underline;}span.EmailStyle17     {font-family:Arial;     color:navy;}@page Section1     {size:8.5in 11.0in;     margin:1.0in 1.25in 1.0in 1.25in;}div.Section1     {page:Section1;}--></style></head><body bgcolor=white lang=EN-US link=blue vlink=blue><div class=Section1><p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:10.0pt;font-family:Arial;color:navy'>Hello All,</span></font></p><p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:10.0pt;font-family:Arial;color:navy'> </span></font></p><p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:10.0pt;font-family:Arial;color:navy'>I am having a problem accessing data in anexcel spread sheet from Vee. I have data that has been stored in Excel as textdata from a control and data acquisition program in Vee.  After the datais stored, I go in manually and open each file of data, save it as an excelspread sheet, and create several graphs from a single group or three groups ofdata. Gets to be very time consuming. I am trying to automate the process usingVee, with the help of a book on excel programming in visual basic, the macros Ihave written which work for only a single graph and the vee sample programs.The problem is the data is of varying lengths and is never the same place forany two data files. My solution is to do a ‘find’ for a null characterwhich would indicate the end of the first row of data. The problem I am havingis that I can not ‘read’ the information that is in an activatecell, in either of the two methods detailed in the vee examples, as a formulaand as a file read.  Any help on reading the data in an excel cell wouldbe appreciated. My system is XP with VEE 6.2.</span></font></p><p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:10.0pt;font-family:Arial;color:navy'> </span></font></p><p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:10.0pt;font-family:Arial;color:navy'>Thank You</span></font></p><p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:10.0pt;font-family:Arial;color:navy'>Doug Cote</span></font></p><p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:10.0pt;font-family:Arial;color:navy'>Che-Yu LI and Company</span></font></p><p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:10.0pt;font-family:Arial;color:navy'> </span></font></p><p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:10.0pt;font-family:Arial;color:navy'> </span></font></p><div><p class=MsoNormal style='margin-left:.5in'><font size=2 face=Arial><spanstyle='font-size:10.0pt;font-family:Arial'>

</span></font></p></div></div>---<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".</BODY></html>  

Outcomes