Re: Bug in (scripting) Excel.
Re: Bug in (scripting) Excel.
- Subject: Re: Bug in (scripting) Excel.
- From: Paul Berkowitz <email@hidden>
- Date: Sat, 27 Sep 2003 21:52:37 -0700
On 9/27/03 9:25 PM, "Deivy Petrescu" <email@hidden> wrote:
>
I got the culprit!
>
It is either me or excel.
>
May be I do not fully understand the meaning of the command, or it is a
>
bug in excel.
>
And I mean that!
>
The problem is the command "set ScreenUpdating to false".
>
As I understand, it means the computer screen is not going to be
>
refreshed, other than that, all the other commands are fully realized.
>
Not true!
>
It replies that the window is active and one might thing that all
>
commands are directed to that window, well, they are not!
>
Because of "set ScreenUpdating to false" the call to activate window,
>
worksheet or workbook, never really brings it to front as we understand
>
front. Although excel replies it did.
>
When I ran the script without "set ScreenUpdating to false" checking
>
to see if the screen was coming to front, the called screen came to
>
front. The script run flawlessly.
>
Running it with "set ScreenUpdating to false" fails misarably.
>
>
Now my question, was I misunderstanding the command or is it a bug in
>
excel ?
>
It is however a drag to not "set ScreenUpdating to false"... It will
>
be much slower.
>
even if it is not a bug, it is a bad implementation.
The trick to understanding Excel AppleScript terms is to look up their
equivalent in the VBA Help.
I don't seem to be able to copy and paste from the Help so you'll have to
look it up yourself. basically, it's designed to run code and calculations
faster by _not_ displaying them on the screen. Therefore it does stand to
reason that it's going to ignore any commands - like Activate - which
specifically relate to screen display, no?
--
Paul Berkowitz
_______________________________________________
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.