Re: Bug in (scripting) Excel.
Re: Bug in (scripting) Excel.
- Subject: Re: Bug in (scripting) Excel.
- From: Deivy Petrescu <email@hidden>
- Date: Sat, 27 Sep 2003 16:46:53 -0400
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. :-(
So that I can clarify something if it is not clear.
Here is the outoput of the log window:
____
tell Application "Microsoft Excel"
set ScreenUpdating to false
current date
date "Saturday, September 27, 2003 16:19:15"
OpenText
"SantosFC:Users:deivy:documents:GBC:Web:Main:Fall_03_exams.xls"
true
OpenText
"SantosFC:Users:deivy:documents:GBC:Web:Main:Fall_03_quizzes.xls"
true
OpenText
"SantosFC:Users:deivy:documents:GBC:Web:Main:Fall_03_attendance.xls"
true
Activate Workbook "Fall_03_exams.xls" --> Active workbook
true
Select Sheet 1
true
get Name of Sheet 1
"298DA"
Select Range "R2C2"
true
LastCell Range "R2C2" Direction xlDown
Range "R8C2" of Worksheet "298DA" of Workbook
"Fall_03_attendance.xls" -->It was never brought to front, the last
-->WB opened
by me.
get Row of Range "R8C2" of Worksheet "298DA" of Workbook
"Fall_03_attendance.xls" --> This should be exams!!!
8
____
Regards
Deivy Petrescu
http://www.dicas.com/
_______________________________________________
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.