Re: AppleScript and Excel VBA returning different values for particular column
Re: AppleScript and Excel VBA returning different values for particular column
- Subject: Re: AppleScript and Excel VBA returning different values for particular column
- From: Wesley Furgiuele <email@hidden>
- Date: Sun, 23 Mar 2003 17:21:17 -0500
Dave:
Thanks, that was exactly the problem.
Wes
On Friday, March 21, 2003, at 06:11 PM, David Wignall wrote:
on 22/3/2003 8:33 AM, Wesley Furgiuele at email@hidden wrote:
set wksA1 to Value of Range("A1") --> Name
set wksB1 to Value of Range("B1") --> CUSIP
set wksC1 to Value of Range("C1") --> 0
set wksD1 to Value of Range("D1") --> Sector
set wksC1 to Address of Range("C1") --> $A:$A
You're being bitten by R1C1 notation and AppleScript thinks you want
column
1. Quite annoying, really. Try this
set wksC1 to Value of Range("R1C3") --> "Ticker"
--
Dave
"Perhaps the truth is less interesting than the facts?"
Amy Weiss,
The RIAA's Senior Vice President of Communications
Email to The Register
_______________________________________________
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.
_______________________________________________
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.