| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Change Pivot Table's query
Hi,
I'm trying to change the sql statement of a Pivot Table through VB6. But, on the following line, pt.PivotCache.sql = StringToArray(ExcelWorkbook.Application.Substitute (pt.PivotCache.sql, OldSQL, NewSQL)) I get the following error: 1004 - Application-defined or object-defined error I've also tried with: pt.PivotCache.CommandText = StringToArray(ExcelWorkbook.Application.Substitute (pt.PivotCache.Command Text, OldSQL, NewSQL)) but I get the same error. Any ideias? *** Sent via Developersdex http://www.developersdex.com *** |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how do I extend an existing pivot table's range | Excel Discussion (Misc queries) | |||
| Identifying Pivot Table's Field | Excel Programming | |||
| Imitating Pivot table's context awareness | Excel Programming | |||
| Accessing Pivot Table's Data in VBA | Excel Programming | |||
| Accessing Pivot Table's Data | Excel Programming | |||
Threaded Mode
