AnsweredAssumed Answered

vrf VEE to Excel CHART

Question asked by fukui.yutaka on Mar 25, 2004
Hi, Mr. Scott Bays,


Excellent! This example led me some steps farther.

Thank you for your efforts.


Best Regards,

FUKUI Yutaka


"BAYES,SCOTT (A-Loveland,ex1)" wrote:
>
> Hello Fukui-san and the vrf,
>
> Although this is not exactly what was requested, there was an example
> presented at most of the VEE Days and FoTA events last year that goes
> a step farther: it shows you how to display the formatted Excel chart
> in a VEE Panel. Quite simple.
>
> It'll probably give you a Caution first time you run it because the
> Picture Object is looking for a jpg file on D: (the VEE Days CD-ROM), but will run fine.
>
> I've attached a copy.
>
> Best Regards,
>
> Scott Bayes
> Software Technical Support
>
> Agilent Technologies, Inc.
> 815 14th Street S.W.
> Loveland, CO, U.S.A. 80537
>
> 970 679 3799 Tel
> 970 635 6867 Fax
>
> > -----Original Message-----
> > From: FUKUI Yutaka [mailto:fukui.yutaka@jp.fujitsu.com]
> > Sent: Tuesday, March 23, 2004 5:58 PM
> > To: PDL-LISTS,VRF (A-Lists,unix1)
> > Subject: [vrf] Re: VEE to Excel CHART
> >
> >
> > Hi,
> >
> >
> > I recommend you to see "Excel97Graph.vee" which you may find in
> >
> > "C:Program FilesAgilentVEE Pro 6.2examplesActiveXAutomation".
> >
> >
> > The following sentences are a part of its explanations:
> >
> > "This example uses Excel97 and ActiveX Automation
> > to insert data into a spreadsheet.  It then instructs
> > Excel to create a new Chart and formats the Chart
> > appropriately."
> >
> >
> > Regards
> >
> >
> > evelascojr@cox.net wrote:
> > >
> > > Hello VRF users,
> > >
> > > I was wondering if anyone can give me a pointer on how to
> > implement VEE to output the data into an excel chart $B!& (Bthe
> > enclosed/attached example takes the data from VEE to excel
> > and I want to be able to add some commands to call excel to
> > create a chart out of the Iout (output current) and the
> > Efficiency column. The y axis is the efficiency and the x
> > axis is the Iout. This way I should be able to make a report
> > from the data generated by VEE to excel with charts without
> > processing the excel data afterwards.
> > >
> > >
> > >
> > > I appreciate any help you can extend regarding this matter.
> > >
> > >
> > >
> > > p.s.  $B!& (Bplease respond using evelascojr@cox.net and not my
> > work email below  $B!& (BI still need to resolve through our systems
> > admin why I can $BCU (B receive any emails from VRF email list.
> > >
> > >
> > >
> > > With kind regards to all,
> > >
> > >
> > > Enrique "IKE" Velasco, Jr.
> > > Engineer/IT
> > >
> > >
> > >
> > > Delta Energy Systems (Arizona), Inc.
> > > 4400 E. Broadway Blvd., Suite 803,
> > > Tucson, AZ, 85715,USA
> > > T +1 520 326 8401
> > > F +1 520 326 8366
> > > M +1 520 370 4537
> > > enrique.velasco@delta-es.com
> > > www.deltaenergysystems.com
> > >
> > >
> > >
> > >
> > >
> > >
> > --------------------------------------------------------------
> > ----------
> > >                    Name: excel_01.vee
> > >    excel_01.vee    Type: VEE Program
> > (application/x-unknown-content-type-VEE.Program)
> > >                Encoding: base64
> > >
> > >
> > --------------------------------------------------------------
> > ----------
> > > ---
> > > You are currently subscribed to vrf as: fukui.yutaka@jp.fujitsu.com
> > > To subscribe send a blank email to
> > "join-vrf@it.lists.it.agilent.com".
> > > To unsubscribe send a blank email to
> > "leave-vrf@it.lists.it.agilent.com".
> > > To send messages to this mailing list,  email "vrf@agilent.com".
> > > If you need help with the mailing list send a message to
> > "owner-vrf@it.lists.it.agilent.com".
> >
> > --
> > *****************************************************************
> > *  $BJ!0f!!K-!J (BFUKUI Yutaka)
> > * E-Mail: fukui.yutaka@jp.fujitsu.com
> > *  $BIY;NDL3t<02q<R!!@n:j9)>l (B
> > *  $B$b$N$E$/$j?d?JKIt!&@8;:5;=Q3+H/E}3gIt!K7WB,@_Hw3+H/It (B
> > *  $B7WB,@_Hw3+H/It (BHomePage http://www.psl.fujitsu.co.jp/htd2/ksk/
> > *  $B@n:j;TCf866h>e>.EDCf#4 (B- $B#1 (B- $B#1!!M9JXHV9f!' (B211-8588
> > * TEL  $B!!30@~ (B 044-754-3657, $B!!Fb@~ (B 711-3-1966,7
> > * FAX  $B!!30@~ (B 044-754-3509, $B!!Fb@~ (B 711-3-5359
> > *****************************************************************
> >
> > ---
> > You are currently subscribed to vrf as: scott_bayes@agilent.com
> > To subscribe send a blank email to "join-vrf@it.lists.it.agilent.com".
> > To unsubscribe send a blank email to
> > "leave-vrf@it.lists.it.agilent.com".
> > To send messages to this mailing list,  email "vrf@agilent.com".
> > If you need help with the mailing list send a message to
> > "owner-vrf@it.lists.it.agilent.com".
> >
>
>   ------------------------------------------------------------------------
>                    Name: excel.vee
>    excel.vee       Type: VEE Program (application/x-unknown-content-type-VEE.Program)
>                Encoding: base64
>             Description: excel.vee
>
>   ------------------------------------------------------------------------
> ---
> You are currently subscribed to vrf as: fukui.yutaka@jp.fujitsu.com
> To subscribe send a blank email to "join-vrf@it.lists.it.agilent.com".
> To unsubscribe send a blank email to "leave-vrf@it.lists.it.agilent.com".
> To send messages to this mailing list,  email "vrf@agilent.com".
> If you need help with the mailing list send a message to "owner-vrf@it.lists.it.agilent.com".

--
*****************************************************************
*  $BJ!0f!!K-!J (BFUKUI Yutaka)
* E-Mail: fukui.yutaka@jp.fujitsu.com
*  $BIY;NDL3t<02q<R!!@n:j9)>l (B
*  $B$b$N$E$/$j?d?JKIt!&@8;:5;=Q3+H/E}3gIt!K7WB,@_Hw3+H/It (B
*  $B7WB,@_Hw3+H/It (BHomePage http://www.psl.fujitsu.co.jp/htd2/ksk/
*  $B@n:j;TCf866h>e>.EDCf#4 (B- $B#1 (B- $B#1!!M9JXHV9f!' (B211-8588
* TEL  $B!!30@~ (B 044-754-3657, $B!!Fb@~ (B 711-3-1966,7
* FAX  $B!!30@~ (B 044-754-3509, $B!!Fb@~ (B 711-3-5359
*****************************************************************

---
You are currently subscribed to vrf as: rsb@soco.agilent.com
To subscribe send a blank email to "join-vrf@it.lists.it.agilent.com".
To unsubscribe send a blank email to "leave-vrf@it.lists.it.agilent.com".
To send messages to this mailing list,  email "vrf@agilent.com". 
If you need help with the mailing list send a message to "owner-vrf@it.lists.it.agilent.com".

Outcomes