• Open Menu Close Menu
  • Apple
  • Shopping Bag
  • Apple
  • Mac
  • iPad
  • iPhone
  • Watch
  • TV
  • Music
  • Support
  • Search apple.com
  • Shopping Bag
 

Lists

Open Menu Close Menu
  • Terms and Conditions
  • Lists hosted on this site
  • Email the Postmaster
  • Tips for posting to public mailing lists
Re: OK, I give up (Or: How to fill in a cell in Excel 2004)
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Re: OK, I give up (Or: How to fill in a cell in Excel 2004)


  • Subject: Re: OK, I give up (Or: How to fill in a cell in Excel 2004)
  • From: "Rebecca O'Connell" <email@hidden>
  • Date: Fri, 28 May 2004 10:38:02 -0400

Paul and Bill:

You were both right, that was the problem. I couldn't tell it was the
problem because, ironically, I was actually looking at the new dictionary,
it was just (apparently) trying to use the old dictionary's values on the
new application (I use Smile). Anyway, its all better now. The correct
answer to my quesiton is:

tell application "Microsoft Excel"
set value of selection to "asdfg"
set x to value of selection
end tell

Note: If you have one cell selected, that one cell will be set to "asdfg"
and x will be "asdfg". If you have two cells selected, both cells selected
will be set to "asdfg" and x will be {{"asdfg", "asdfg"}}.

Thanks for everybody's help.
-Rebecca

On 5/27/04 10:57 PM, "Bill" <email@hidden> wrote:

> Rebecca,
>
> Last week I had the same problem, one of the kind lister, Paul,
> suggested:
>
>>
>> Oh yes - most script editors (certainly SD) need to be quit and
>> relaunched
>> after using one version of a scriptable app then switching to another.
>> Otherwise they keep the old dictionary in memory. That's what must have
>> happened to you.
>>
>> Quit Excel X (you probably did that already).
>> Quit Script Editor (or whichever editor you're using).
>> Launch Excel 2004.
>> Launch Script Editor.
>> Open Excel 2004's dictionary.
>
> Afterwards, you can continue the trial ;)
>
> IMO, the dictionary changes a lot, be patient to re-learn it.
>
>
> bill
>

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.


References: 
 >Re: OK, I give up (Or: How to fill in a cell in Excel 2004) (From: Bill <email@hidden>)

  • Prev by Date: Re: Saving HTML from Entourage
  • Next by Date: Re: Filling a cell in Excel
  • Previous by thread: Re: OK, I give up (Or: How to fill in a cell in Excel 2004)
  • Next by thread: Filling a cell in Excel
  • Index(es):
    • Date
    • Thread