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"

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"