OK there are absolutely no good articles on the internet that I can find that explain or have code examples on how to create a pivot chart using VBA. I need this because I need the pivot chart to show different results depending on user selection in a form. There are some for Excel but the syntax is different for Access. I know this is a lame question, but if anyone has an example of how to create a pivot chart in VBA I would really appreciate the help.
+1
A:
Well after about 3 days of searching I think I found it. Not that anyone really cares, this only has like 6 views, says a lot for VBA's utter horribleness. Anyway, MSDN had this hidden under "Office XP" instead of under Access, but whatever.
Nick S.
2009-04-15 11:37:53
David-W-Fenton
2009-04-16 00:46:53
A:
Hello Greekness,
I stumped upon your question by luck since I have been researching this for over a week. I am having the exact same problem as you. I checked the url and it was alright but I was wondering if you have found more information on this vexing problem?
Matt
Matthew
2009-12-02 15:47:45
Actually what I ended up doing was having a pre-made excel sheet with pivot tables already made, and I threw all of my data into the excel file, then opened the excel file, inside of the excel file I had to set it up to always grab eveything in the entire column that way the info was always right. After that I didn't have to do anything. It would automatically refresh on open with a short line of VBA and I was done. It was easier then getting Access to do it.
Nick S.
2009-12-13 19:37:16