DiGregorio, Dave wrote:
> So that gives me the ASCII Value. But I am looking for the 1-for-1
> value. A = 1
> B = 2
> C = 3
>
> AA = 27
> AB = 28
>
> As the columns in Excel is are labeled
>
> So I have a Value at max row AN which is 40 Columns in the Excel
> Worksheet. Using the below meth
this value. Any Ideas??
>
> Thanks
>
> d
>
>
>
> -Original Message-
> From: Colm Gallagher [mailto:[EMAIL PROTECTED]
> Sent: Thursday, August 26, 2004 2:55 AM
> To: DiGregorio, Dave
> Cc: perl_help
> Subject: Re: Help With OLE
>
> Hi David,
' and I do pull
this value. Any Ideas??
Thanks
d
-Original Message-
From: Colm Gallagher [mailto:[EMAIL PROTECTED]
Sent: Thursday, August 26, 2004 2:55 AM
To: DiGregorio, Dave
Cc: perl_help
Subject: Re: Help With OLE
Hi David,
First post to this list, so hi folks, pleasure to me
Hi David,
First post to this list, so hi folks, pleasure to meet you all.
To get the text (i..e showing currency symbols etc.) out of a field
instead of the numeric value, use the Text property instead of Value
property.
sub toLetter {
return chr(64+$_[0]);
}
$ReadData = $ReadSh
