Suggestions, Tips or Tricks to writing code for Pivot Tables?

[USAMax]

I have written Excel VBA for years but never for creating Pivot Tables, I will be starting a new project that requires Pivot Tables. Can anyone suggest a good article or a good link for general pivot table tips and tracks using VBA? I have Excel 2010.

Thank you!

 

[par60056]

I found that the best way to get started it to record doing simple things and then using the help to examine the objects that it is using. The code written by the recorder is verbose and not very generalized. But you can look at the parameters and see what it is doing and then make it more general.

I have read many VBA programming books and usually find the depth stops right about where I wish it would start.

 

[USAMax]

Thank you Par60056,

That is my plan when I get into the work but I had hoped to prepare a little before they give me the work. My favorite saying is, "People don't plan to fail, they fail to plan." so I am just thinking ahead.

Thank you again!

 

[par60056]

Since you are going to be working in 2010, there are a lot of things that are new to pivot tables. Coding the pivot table features is not hard. Learning all the things you can do in the pivot table is. I would not be worried about learning the VBA but try finding good references to the changes in pivot tables in 2007 and 2010. 2007 changed some things and 2010 lots of new features (I don't use them yet so I can't explain them)