OK, I give up (Or: How to fill in a cell in Excel 2004)
OK, I give up (Or: How to fill in a cell in Excel 2004)
- Subject: OK, I give up (Or: How to fill in a cell in Excel 2004)
- From: "Rebecca O'Connell" <email@hidden>
- Date: Thu, 27 May 2004 17:23:15 -0400
Folks:
I just downloaded the trial copy of Office 2004 and it's "improved and
expanded" implementation of applescript has broken all of my existing Excel
applescripts, which I9m given to understand it was supposed to do. Well, it
did it. Now I can9t figure out how to fix it. I know there9s supposed to be
a manual coming out, but if some more dictionary-savy person here could tell
me how to do just one or two simple things while I9m waiting for it, I would
really appreciate it.
The things I would really like to know how to do are get and set the value
of a cell. If I tell it to "return first cell of selection" when I have cell
R1C1 selected, I get...
+class X117; "$A$1" of selection of application "Microsoft Excel" (+class
X117; appears to be the range class).
...so I can get a range, but I cannot for the life of me figure out how to
get or set the value of a cell in the range.
Formula is listed as a property of the range class, but when I ask it to
"return formula of selection" I get "missing value".
I9ve tried...
set first Cell of Selection to "asdf"
set Selection to "asdf" (with a single cell selected)
set Value of Selection to "asdf"
set Value of first Cell of Selection to "asdf"
set Formula of first Cell of Selection to "asdf"
set Formula of Selection to "asdf"
set FormulaR1C1 of Selection to "asdf"
set text of Selection to "asdf"
--with no luck.
It also won't let me activate the application any more ("can't continue
Activate..."). I still have Excel 2001 on my computer and it is called by
the same name ("tell app 'Microsoft Excel'") so maybe that is the problem
with that.
The good news is that all of my Entourage scripts that I9ve tried so far and
my MS Word Find and Paste function, are still working. The ones that use
Word will work in which ever version of Word I happen to have running (or
2004 if I have them both running). Sweet.
Thank you,
Rebecca
Sent using the Microsoft Entourage 2004 for Mac Test Drive.
_______________________________________________
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.