Re: Excel: hide multiple columns with Applescript
Re: Excel: hide multiple columns with Applescript
- Subject: Re: Excel: hide multiple columns with Applescript
- From: David Wignall <email@hidden>
- Date: Tue, 22 Mar 2011 09:13:42 +1300
On 22 Mar 2011, at 6:22 AM, Paul Berkowitz wrote:
> On 3/21/11 2:21 AM, "David Wignall" <email@hidden> wrote:
>
>> All of which works but when I tested with a different field, one with 89 items
>> it took a noticeable time, complete with SPOD but less than 1 minute, to
>> create the list of names. However it took no real time at all to hide all
>> those fields, so if you already know the names then that's irrelevant.
>> (Errored on the last one because at least 1 field must be visible).
>
> Sometimes, if you 'set screen updating to false' before beginning such an
> operation via AppleScript, then setting it back to true when done, you can
> save a lot of time and speed it up. Does that help in this circumstance?
>
> ('screen updating' is a property of the application, so should be done in a
> tell app "Microsoft Excel" block without any internal tell blocks around
> it.)
Nothing was apparently happening on screen but it's always worth a try :-)
<testing />
No difference though. It takes around 50 seconds to work through the pivot items whether the line is
name of pivot items of...
or simply
pivot items of...
However this is from a Smile terminal window. If I save a script in XL 2008's script menu then it takes less than 1 second; that's that problem solved.
Turning screenupdating off and on might help at the 'set visible ... to false' part as there is animation happening on the worksheet at that point.
--
Dave _______________________________________________
Do not post admin requests to the list. They will be ignored.
AppleScript-Users mailing list (email@hidden)
Help/Unsubscribe/Update your Subscription:
Archives: http://lists.apple.com/archives/applescript-users
This email sent to email@hidden