Re: Read a cell in Excel 2004
Re: Read a cell in Excel 2004
- Subject: Re: Read a cell in Excel 2004
- From: Nan Mossey <email@hidden>
- Date: Wed, 10 Nov 2004 10:35:10 -0500
I'm having trouble with this, as well. I'm creating list of variables from
an an excel sheet to be transferred to another database . Info varies from
numbers to text to date. I've changed this (excel X):
set Pubdate to text of cell "r3c2"
To this (excel 2004):
set Pubdate to value of range ("B3")
And also
set Pubdate to (get value of range ("B3"))
And also
set Pubdate to value of range ("B3") as string
...with no success.
Any help out there? Thanks.
On 11/4/04 1:07 PM, "David Wignall" <email@hidden> wrote:
> on 5/11/2004 5:13 AM, Studio G sarl at email@hidden wrote:
>
>> Hi !
>> Can someone help me to read a cell in Excel 2004 ?
>> All my old scripts (OS 9) failed...
>
> Either
>
> value of range ("A1")
>
> or
>
> formula of range ("A1")
>
> depending on what you want. 'Text of range' no longer works...
--
Nan Mossey
Times Union Publications Manager
1 News Plaza
Albany NY 12212
518-454-5704
========================================================
This e-mail message is intended only for the personal
use of the recipient(s) named above. If you are not
an intended recipient, you may not review, copy or
distribute this message.
If you have received this communication in error,
please notify the Albany Times Union Help Desk
(email@hidden) immediately by e-mail and
delete the original message.
========================================================
_______________________________________________
Do not post admin requests to the list. They will be ignored.
Applescript-users mailing list (email@hidden)
Help/Unsubscribe/Update your Subscription:
This email sent to email@hidden