Posted to microsoft.public.excel.programming

Roberto Villa Real Roberto Villa Real is offline

external usenet poster

Posts: 3

Changing PivotTable Source programmatically

I have several pivot tables in a workbook that get data from an Access .mdb
file.

But sometimes I need these pivot tables to obtain data from another Access
file.

Can I programmatically change the Source File of a Pivot Table, without
changing its query? Shall I use the PivotTableWizard? Or is there any
property that contains the Source File path?

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Programmatically getting a Max value from a PivotTable	WhytheQ	Excel Programming	1	October 25th 06 02:32 PM
Programmatically determine Chart's data source	drussell	Excel Programming	2	March 4th 06 05:25 AM
Programmatically reading data field values from PivotTable	Enrico Campidoglio[_2_]	Excel Programming	2	July 13th 05 12:32 PM
Excel VBA - How do I programmatically change source code in another file?	Lisa Norgaard	Excel Programming	1	July 14th 04 04:09 PM
Changing PivotTable source	atakacs[_2_]	Excel Programming	3	November 7th 03 03:35 AM

All times are GMT +1. The time now is 10:31 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us