AnsweredAssumed Answered

AW: vrf format Excel cells as time

Question asked by VRFuser on Jan 14, 2008
Best way to find out the xlapp.something activeX commands is : recording the macro - assuming you know how you do this within excel itself.
detlef

-----Ursprüngliche Nachricht-----
Von: NEBENDAHL,BERND (A-Germany,ex1) [mailto:bernd_nebendahl@agilent.com]
Gesendet: Freitag, 11. Januar 2008 18:52
An: VRF
Betreff: RE: [vrf] format Excel cells as time

Hello again,

I found out how to do that (use custom format yy/mm/dd hh:mm:ss for the cell format). Now I would like to modify the location of the axes, change the font of the axes labels and the location of the whole graph (as a separate sheet) that I created using the CreatXYchart.

Thank you
Bernd

> -----Original Message-----
> From: NEBENDAHL,BERND (A-Germany,ex1)
> Sent: Friday, January 11, 2008 17:52
> To: PDL-LISTS,VRF (A-Lists,unix1)
> Subject: [vrf] format Excel cells as time
>
> Hello all,
>
> after I figured out how to convert VEE-time obtained by now() to the
> Excel-time obtained by Now() I'm left with the problem how to change
> the format of an Excel cell to a time (or
> date/time) format.
>
> Any ideas?
>
> Bernd
>
>
> ---
> You are currently subscribed to vrf as:
> bernd_nebendahl@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".
>
>


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