Re: Read a cell in Excel 2004
Re: Read a cell in Excel 2004
- Subject: Re: Read a cell in Excel 2004
- From: Paul Berkowitz <email@hidden>
- Date: Wed, 10 Nov 2004 07:46:20 -0800
On 11/10/04 7:35 AM, "Nan Mossey" <email@hidden> wrote:
> 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.
set Pubdate to value of cell "B3"
or
set Pubdate to value of cell "$B$3" -- absolute reference
should be working fine. If the value is text it will be Unicode.
range "B3" should work too. Are you sure you have that worksheet in front?
Since you're not specifying a sheet or workbook Excel will use the active
sheet by default. If you want another sheet or workbook you have to say so.
--
Paul Berkowitz
_______________________________________________
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