RE: Bug in (scripting) Excel
RE: Bug in (scripting) Excel
- Subject: RE: Bug in (scripting) Excel
- From: Jay <email@hidden>
- Date: Sat, 27 Sep 2003 18:20:45 -0500
Hi Deivy,
Does something like this work?
---------------
tell application "Microsoft Excel"
Activate
Activate Workbook 1
end tell
---------------
I'm using OS 10.2.7 with Excel X. It didn't work at first but when I
told Excel to activate it seemed to work (for now at least). I've had
similar problems before with Excel X not bringing the correct window up
front. Is Excel the active app when your Script is running? Do you
have a snippet of code I could test here?
Jay
---------------
On Saturday, September 27, 2003, at 04:52 PM,
email@hidden wrote:
>
Message: 13
>
Date: Sat, 27 Sep 2003 16:27:46 -0400
>
Subject: Re: Bug in (scripting) Excel.
>
From: Deivy Petrescu <email@hidden>
>
To: kai <email@hidden>, applescript
>
<email@hidden>
>
>
On Saturday, Sep 27, 2003, at 16:12 US/Eastern, kai wrote:
>
>
> on 27/9/03 9:00 pm, I wrote:
>
>
>
>> on Fri, 26 Sep 2003 13:26:18 -0400, Deivy Petrescu wrote:
>
>>
>
>>> I think I found a bug on scripting Excel.
>
>>
>
>> [snip]
>
>>
>
>>> activate window n1
>
>>
>
>> [snip]
>
>>
>
>> Have you tried <Activate Workbook n1>, Deivy?
>
>>
>
>> Or, if you want a specific worksheet, <Activate Worksheet 2 of
>
>> Workbook n1>.
>
>
>
> Nah! I've tried <Activate Workbook n1> and <Activate Window n1> - and
>
> they
>
> both work for me. Must be something else your end. :-(
>
>
>
> ---
>
> kai
>
>
>
>
Can you clarify that?
>
Are you saying that if you open more than one Workbook it works when
>
try to get a range?
>
I've tried Activate W(hatever) and the behaviour is always the same. It
>
reads the range of the last name of my list of names.
>
Do you get a different behaviour here?
>
If so, can we share the codes and see what is different?
>
>
Here
>
10.2.8 (is this my problem?)
>
AppleScript 1.9.1
>
S.E. 2.0 (v36)
>
Excel X for Mac Service Release 1
>
>
>
Thanks
_______________________________________________
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.