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" <reply@tonewsgroup.com> wrote in message
news:eZoWS6v7FHA.2012@TK2MSFTNGP14.phx.gbl...
> Posted to Programming to get a faster reply.
>
> "lj" <lj@spu.edu> wrote in message
> news:1132600147.868091.262230@g14g2000cwa.googlegroups.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"
> >
>
>