Re: pivot table
Re: pivot table
- Subject: Re: pivot table
- From: Paul Berkowitz <email@hidden>
- Date: Wed, 13 Feb 2008 00:29:05 -0800
- Thread-topic: pivot table
There's no "code below". There's just a very lengthy company disclaimer,
with no subtotals that I can see.
Have you studied the Excel AppleScript Reference from
http://www.microsoft.com/mac/developers/default.mspx ? You can find various
pivot table-related classes and commands in the Microsoft Excel Suite (make
sure to check 'get pivot table data' in commands), all of whose names
correspond to their VBA equivalents. Read the introductory section of the
Reference too, I also see that the updated website has a copy of my
VBA-to-AppleScript guide - read the first chapter and Excel chapter, though
there's nothing specific about pivot tables, sorry.
--
Paul Berkowitz
From: Steve Digby <email@hidden>
Date: Tue, 12 Feb 2008 22:26:29 +0000
To: <email@hidden>
Subject: pivot table
Hi,
I am using an Imac running Leopard 10.5 and have created a pivot table that
is created from data automatically exported from Filemaker pro. However, I
have not had extensive practice at scripting excel and cannot work out
how/if you can Applescript subtotals to be set to none. The code below shows
how you can do this using VB, but I am using office 2008, which no longer
supports VB. And cannot work out if the code below can be translated to
Applescript. I would be very grateful if anyone could give me any
help/advice regarding this problem.
Thanks,
Stephen Digby
This message and any attachments are intended solely for the addressees and
are confidential. If you receive this message in error, please delete it and
immediately notify the sender.
The Chrysalis Group cannot accept liability for any statements, views or
opinions made which are clearly the sender's own and not expressly made on
behalf of the Chrysalis Group.
The contents may contain information which is confidential and may also be
privileged. It may not be copied, used or disclosed without authorisation.
Chrysalis Group plc
Registered Office: The Chrysalis Building, 13 Bramley Road, London, W10 6SP
Registration Number: 946978 England
_______________________________________________
Do not post admin requests to the list. They will be ignored.
AppleScript-Users mailing list (email@hidden)
Help/Unsubscribe/Update your Subscription:
om
Archives: http://lists.apple.com/archives/applescript-users
This email sent to email@hidden
_______________________________________________
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
| References: | |
| | >pivot table (From: "Steve Digby" <email@hidden>) |