[ExcelVBA] How to identify the data source (or connection) for a pivot table using VBA

 

Hi All,

I am writing a macro that will modify filters for multiple pivot tables at the click of a button. I have been successful in that part however, some of my pivot tables have different pivot fields to filter on. If I can determine the source of the table, I can adapt my code but I have been unable to find the proper way to determine the underlying data source. Any thoughts or suggestions?

Thanks,
Mitch

__._,_.___

Reply to sender | Reply to group | Reply via web post | Start a New Topic

Messages in this topic (1)

Recent Activity:

• New Members 8

Visit Your Group

----------------------------------
Be sure to check out TechTrax Ezine for many, free Excel VBA articles! Go here: http://www.mousetrax.com/techtrax to enter the ezine, then search the ARCHIVES for EXCEL VBA.

----------------------------------
Visit our ExcelVBA group home page for more info and support files:
http://groups.yahoo.com/group/ExcelVBA

----------------------------------
More free tutorials and resources available at:
http://www.mousetrax.com

----------------------------------

Switch to: Text-Only, Daily Digest • Unsubscribe • Terms of Use

.

__,_._,___