Re: Excel 2004
Re: Excel 2004
- Subject: Re: Excel 2004
- From: Dave Balderstone <email@hidden>
- Date: Fri, 14 Dec 2007 14:44:32 -0600
On 14-Dec-07, at 2:32 PM, Paul Berkowitz wrote:
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
As usual, I just copied code from an existing script. In that
particular one I'm incrementing the cell #
_______________________________________________
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