| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel,microsoft.public.excel.programming
|
|||
|
|||
Visual Basic Question
Posted to Programming to get a faster reply.
"lj" wrote in message oups.com... I have the following formula that I use in visual basic to update a pivot table from a pivot table. I want to alter the formula to update a pivot table from a set of data (that was brought in from a query to excel). How do I alter my formula below? Sheets("Commissions").Select ActiveSheet.PivotTableWizard SourceType:=xlPivotTable, SourceData:= _ "[Munge_Report.xls]Data!Query" |
|
#2
Posted to microsoft.public.excel,microsoft.public.excel.programming
|
|||
|
|||
|
Visual Basic Question
Why not turn on the macro recorder and try to perform the action manually.
That should give you code specific to your situation. -- Regards, Tom Ogilvy "Barb Reinhardt" wrote in message ... Posted to Programming to get a faster reply. "lj" wrote in message oups.com... I have the following formula that I use in visual basic to update a pivot table from a pivot table. I want to alter the formula to update a pivot table from a set of data (that was brought in from a query to excel). How do I alter my formula below? Sheets("Commissions").Select ActiveSheet.PivotTableWizard SourceType:=xlPivotTable, SourceData:= _ "[Munge_Report.xls]Data!Query" |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Visual Basic Question | Excel Worksheet Functions | |||
| visual basic coding question | Excel Discussion (Misc queries) | |||
| Visual Basic Question | Excel Discussion (Misc queries) | |||
| Visual Basic Mail Question | Excel Programming | |||
| Visual Basic Question | Excel Programming | |||
Hybrid Mode
