Re: How is the applescript support in Office 2004?
Re: How is the applescript support in Office 2004?
- Subject: Re: How is the applescript support in Office 2004?
- From: Paul Berkowitz <email@hidden>
- Date: Fri, 21 May 2004 06:35:17 -0700
On 5/21/04 5:13 AM, "Walter Ian Kaye" <email@hidden> wrote:
>
At 12:37p -0700 05/20/2004, Paul Berkowitz didst inscribe upon an
>
electronic papyrus:
>
>
> BTW, one big difference in Excel scripting is that you can no longer use
>
> R1C1 style references. (Aside from anything else, there were terrible bugs
>
> in French and German Excel which had their own versions - "S1C1" etc. but
>
> results were returned as RICI so it couldn't understand its own results!)
>
> "A1" works: best is to use "absolute values "$A$1", i.e., using the column
>
> and row denominators exactly as they appear in the worksheet.
>
>
Hmm. So then how would you write a script to do something with the
>
cell 1 row above the active cell, if you can't do R[-1]C?
There are a few ways. One way would be:
set higherCell to get offset (active cell) row offset -1
If you need to you can then check on its coordinates by:
set {r, c} to {first row index, first column index} of higherCell
--
Paul Berkowitz
_______________________________________________
applescript-users mailing list | email@hidden
Help/Unsubscribe/Archives:
http://www.lists.apple.com/mailman/listinfo/applescript-users
Do not post admin requests to the list. They will be ignored.