Re: VBA to Applescript
Re: VBA to Applescript
- Subject: Re: VBA to Applescript
- From: Paul Berkowitz <email@hidden>
- Date: Thu, 14 Feb 2008 12:42:12 -0800
- Thread-topic: VBA to Applescript
On 2/14/08 11:18 AM, "Paul Berkowitz" <email@hidden> wrote:
> set subtotals subtotal index 1 value false
Sorry, in all these examples I omitted to specify the direct object, namely
the pivot field pt.
So all of them should be of the form:
set subtotals pt subtotal index 1 value false
E.g. the final compact version would be:
tell application "Microsoft Excel"
repeat with i from 1 to (count pivot tables of active sheet)
set pt to pivot table i of active sheet
repeat with j from 1 to (count pivot fields of pt)
repeat with k from 1 to 12
try
set subtotals pt subtotal index k with value
set subtotals pt subtotal index k without value
end try
end repeat
end repeat
end repeat
end tell
I'm sort of dubious that this will work, but give it a try.
--
Paul Berkowitz
_______________________________________________
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