Visual Basic Question

[lj]

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"

[Barb Reinhardt]

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"
>

[Tom Ogilvy]

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"
> >
>
>