Re: Excel 2004
Re: Excel 2004
- Subject: Re: Excel 2004
- From: Paul Berkowitz <email@hidden>
- Date: Fri, 14 Dec 2007 12:32:09 -0800
- Thread-topic: Excel 2004
On 12/14/07 12:03 PM, "Dave Balderstone" <email@hidden>
wrote:
> For B15 I'd use:
>
> tell application "Microsoft Excel"
> set theVar to value of cell 15 of column 2
> end tell
>
In Excel 2004, which uses A1 type addresses, you don't need to figure out
which column number (easy enough for B, a little harder for BW, say). Plus I
seem to recall some bugs to do with columns.
Just:
tell application "Microsoft Excel"
set theVar to value of cell "B15"
end tell
--
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:
Archives: http://lists.apple.com/archives/applescript-users
This email sent to email@hidden