No bounds checking, of course. -- Bill Ossmann Philips Ultrasound e-mail: bill.ossmann@philips.com ------------------------------------------------------------------------------------------------------
Does someone has a nice functions in Vee availble to transform the numbers 1-256 into Excel - Cell formats A,B,C ...AA,AB, AC etc. ? And maybe vice versa ?
Or is there an excel function to do so ?
Thanks for any help, detlef
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.
--- You are currently subscribed to vrf as: bill.ossmann@philips.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".
--- 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".
This one escaped the board last time I posted. Has anyone tried to put error bars on Excel charts using ActiveX from within VEE?
Shawn, nice to have you back. Agilent should pay for your cable internet (and provide you with in-home wireless networking) for all the help you give their sales staff by supporting this board. Incidentally, I believe that Apple are only in business today because of their presence in the academic and research world.
Best wishes and happy surfing, Richard.
On Apr 8, 2004, at 12:40 PM, BAYES,SCOTT (A-Loveland,ex1) wrote:
------------------------------------------ Dr. Richard J.A. Wilson University of Calgary,
--- 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".
I believe it returns the text "a1" or similar. Not sure how to reverse.
Andrew Fudge Wales UK
----- Original Message ----- From: "Baranski, Detlef" <Detlef.Baranski@PILKINGTON.de> To: "VRF" <vrf@agilent.com> Sent: Thursday, April 08, 2004 3:33 PM Subject: [vrf] [vrf]- Numbers (1-201etc) to Excel like cell A,B,C...AA etc. ?
> Does someone has a nice functions in Vee availble to transform the numbers > 1-256 into Excel - Cell formats A,B,C ...AA,AB, AC etc. ? And maybe vice > versa ? > > Or is there an excel function to do so ? > > Thanks for any help, > detlef > > > 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: AndrewF@genesysibs.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". >
--- 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".
Does someone has a nice functions in Vee availble to transform the numbers 1-256 into Excel - Cell formats A,B,C ...AA,AB, AC etc. ? And maybe vice versa ?
Or is there an excel function to do so ?
Thanks for any help, detlef
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.
--- 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".
Try this:
(x<27 ? intToChar(64+x) :
intToChar(64+intPart(x/26))+intToChar(64+26*FracPart(x/26)))
No bounds checking, of course.
--
Bill Ossmann
Philips Ultrasound
e-mail: bill.ossmann@philips.com
------------------------------------------------------------------------------------------------------
Does someone has a nice functions in Vee availble to transform the numbers
1-256 into Excel - Cell formats A,B,C ...AA,AB, AC etc. ? And maybe vice
versa ?
Or is there an excel function to do so ?
Thanks for any help,
detlef
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: bill.ossmann@philips.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".
---
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".