asked on Excel 2010 - Pivot Table from a Recordset
I can get my PivotTable data into a recordset from an external database. OK.
I'm looking for the minimal code required to create a PivotTable with this data.
Say, on "Sheet1", at "A1", with Page Fields "CustomerType" and "Country", Row Field "Customer", Values "Count of Shops".
Thanks.
(I tried recording a macro but translating it to datasource = recordset is where I'm stuck)
I'm looking for the minimal code required to create a PivotTable with this data.
Say, on "Sheet1", at "A1", with Page Fields "CustomerType" and "Country", Row Field "Customer", Values "Count of Shops".
Thanks.
(I tried recording a macro but translating it to datasource = recordset is where I'm stuck)
Microsoft ExcelVBAMicrosoft Office
Last Comment
Shums Faruk
ASKER CERTIFIED SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
No comment has been added to this question in more than 14 days, so it is now classified as abandoned.
I have recommended this question be closed considering ID: 42068362 as best solution
If you feel this question should be closed differently, post an objection and a moderator will read all objections and then close it as they feel fit. If no one objects, this question will be closed automatically the way described above.
I have recommended this question be closed considering ID: 42068362 as best solution
If you feel this question should be closed differently, post an objection and a moderator will read all objections and then close it as they feel fit. If no one objects, this question will be closed automatically the way described above.
It would be helpful if you provide sample workbook.