AnsweredAssumed Answered

vrf About getting HD serial number using VEE

Question asked by VRFuser on Jan 6, 2008
Keep in mind that by using the excel lib the object name is  ... xlapp.something ...
just put that into the formula object...
detlef 

  _____  

Von: Robert Rais [mailto:Robert.Rais@us.yazaki.com]
Gesendet: Donnerstag, 3. Januar 2008 15:20
An: VRF
Betreff: RE: [vrf] Add new data series to a existing chart with excel library


James, 
 
Use the bolded code for adding a new data series to your chart.  I used the excel 97 example and modified it to add a second data series. Just change the data location to add the series.
 
Robert
 
sheet.ChartObjects.Add(0,0,420,220);
sheet.ChartObjects(1).Activate;
book.ActiveChart.ChartType=xlLineMarkers;
book.ActiveChart.SetSourceData(ChartRange, xlColumns);
book.ActiveChart.SeriesCollection(1).Delete;
book.ActiveChart.SeriesCollection.NewSeries();
book.ActiveChart.SeriesCollection(1).XValues = "=Sheet1!R20C1:R50C1";
book.ActiveChart.SeriesCollection(2).Values = "=Sheet1!R20C1:R50C1";

  _____  

From: James Zhang [mailto:James.Zhang@rfsworld.com]
Sent: Tuesday, January 01, 2008 9:17 PM
To: VRF
Subject: [vrf] Add new data series to a existing chart with excel library



Hi all!

I'm using VEE7.5 and what i'd like to do is to add some new data series to a predefined chart in a excel file by using the excel library, it seems there's no such function included in the library, can someone guide me on how to realize this?

Thanks!
--- You are currently subscribed to vrf as: Robert.Rais@us.yazaki.com To subscribe please send an email to: "vrf-request@lists.it.agilent.com" with the word subscribe in the message body. 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". Search the "unofficial vrf archive" at "http://www.vrfarchive.com/vrf_archive". Search the Agilent vrf archive at "http://vee.engineering.agilent.com".
---
You are currently subscribed to vrf as: Detlef.Baranski@pilkington.de
To subscribe please send an email to: "vrf-request@lists.it.agilent.com" with the word subscribe in the message body.
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".
Search the "unofficial vrf archive" at "http://www.vrfarchive.com/vrf_archive".
Search the Agilent vrf archive at "http://vee.engineering.agilent.com".
Der Inhalt dieser E-Mail (inkl. aller Anlagen) ist vertraulich und ausschließlich für den Adressaten bestimmt. Jede Art der Verbreitung, Nutzung oder Vervielfältigung ist untersagt. Sollten Sie diese E-Mail irrtümlich erhalten haben, informieren Sie bitte sofort den Absender und löschen die E-Mail.

Unternehmensangaben der Gesellschaften mit Sitz in Deutschland:

Pilkington Holding GmbH, Haydnstraße 19, 45884 Gelsenkirchen
Sitz: Gelsenkirchen, Amtsgericht Gelsenkirchen HRB 8997
Geschäftsführung: Jochen Settelmayer (Vorsitz), Dr. Clemens Miller, Thomas Kretschmann, Robert Hales
Vorsitzender des Aufsichtsrates: Dr. Axel Wiesener

Pilkington Deutschland AG, Haydnstraße 19, 45884 Gelsenkirchen
Sitz: Gelsenkirchen, Amtsgericht Gelsenkirchen HRB 2707
Vorstand: Dr. Clemens Miller, Jochen Settelmayer
Vorsitzender des Aufsichtsrates: Dr. Axel Wiesener

Pilkington Automotive Deutschland GmbH, Otto-Seeling-Straße 7, 58455 Witten
Sitz: Witten, Amtsgericht Bochum HRB 8443
Geschäftsführung: Thomas Kretschmann
Vorsitzender des Aufsichtsrates: Jochen Settelmayer

Bauglasindustrie GmbH, Hüttenstraße 33, 66839 Schmelz / Saar
Sitz: Schmelz / Saar, Amtsgericht Saarbrücken HRB 52020
Geschäftsführung: Manfred Ebbers


---
You are currently subscribed to vrf as: ming_meng@agilent.com
To subscribe please send an email to: "vrf-request@lists.it.agilent.com" with the word subscribe in the message body.
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".
Search the "unofficial vrf archive" at "http://www.vrfarchive.com/vrf_archive".
Search the Agilent vrf archive at "http://vee.engineering.agilent.com".  

Outcomes