AnsweredAssumed Answered

vrf AW: vrf:Excel XValue Problem

Question asked by bernhardt on Apr 14, 2004
Hello Detlef,

for german EXCEL the formula for the Xvalues has to be:
str = "=Tabelle1!Z2S2:Z" + (totsize(data)+1)  + "S2";

This works.

Best regards

M. Bernhardt
---------------------------------------------
SOMATEC - Software fr Maschinensteuerungen
und Automatisierungstechnik GbR

Jagdweg 7a
D-82041 Deisenhofen

Telefon :  (089) 613 984 94
Fax :      (089) 613 981 23
Email :    Bernhardt@somatec.de
homepage : www.somatec.com
---------------------------------------------


-----Ursprngliche Nachricht-----
Von: Baranski, Detlef [mailto:Detlef.Baranski@PILKINGTON.de]
Gesendet: Mittwoch, 14. April 2004 15:33
An: VRF
Betreff: [vrf] RE: [vrf]:Excel XValue Problem -- plus Web-site My-Vee.de

Sorry, Shawn,
it is not mine.

I am more or less a rookie

But it helps me a lot in understanding Vee. It is from a german VEE - FAN
which nickname is bratbaecker, and i do not know if he is on this
mailing-list.
Maybe a translation is usefull ? But many of these things can be seen at
preciseelectro, too...

But of course, i love his web-design, too !

For those germans who are not so familiar with english, there is a german
Vee- Mailinglist , too.
----
Es gibt eine deutschsprachige Vee-MAilinglist- insbesondere fuer diejenigen,
die die Probleme in Englisch nicht so toll schildern koennen.
Es ist eine gute Ergaenzung zur VRF- soll sie aber nicht ersetzen Bei
Interesse Mail an: deutscheVee-Mailinglist@gmx.de .
----

Coming back to Excel Prob:

Thanks, Andrew.
I did change the system-preferences to English-British ( so that , is. and .
is , ) , but there is no change of the problem.
The line which makes this prob is:

book.ActiveChart.SeriesCollection(1).XValues = str;

I can not change Excel 97 to an english version.

Program attached...


-----Ursprngliche Nachricht-----
Von: Shawn Fessenden [mailto:shawn@testech-ltd.com]
Gesendet: 14 April 2004 16:11
An: VRF
Betreff: [vrf] RE: [vrf]:Excel XValue Problem


> By the way, a good overview of MS-Office and esp.Excel
> automisation can be found at: www.my-vee.de/zips/autohilfe.zip

Wow! Great file Detlef. Thanks.

Is that your VEE site? I like the part about "no cookies, no jscript, no
frames" Looks great - I just wish I could read German. Bable does a
decent job though.

Say I have one little gripe with the text of the help file. When discussing
binding, it says that late binding is declaring an object of specific class.
This is a typo. Late binding occurs when you declare an object of
*inspecific* class, then assign a specific object to it.
-SHAWN-

This message and any attachments are confidential, for the exclusive use of
the addressee and may be legally privileged. Any other distribution, use or
reproduction is unauthorised and prohibited. If you have received this
message in error, please notify the sender immediately and delete the
message from your system.

Visit our internet site at http://www.pilkington.com


---
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