Visual Basic Question

L

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

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 said:
Posted to Programming to get a faster reply.

lj said:
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"
Click to expand...
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Dates In Excel 5
Append Crosstab Query to Existing Table 0
Dealing with a Pivot Table (when I don't want to) 0
Upadte PivotTable Data range 2
Teams Rooms Basic Licence 0
How to display zero value in blank fields of Cross Tab query 0
SUM & OFFSET & PIVOT TABLE?? 0
Getpivot data not referencing properly 0

Top