Mailing Lists: Apple Mailing Lists
Image of Mac OS face in stamp
Re: pivot table
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Re: 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>)



Visit the Apple Store online or at retail locations.
1-800-MY-APPLE

Contact Apple | Terms of Use | Privacy Policy

Copyright © 2011 Apple Inc. All rights reserved.