Excel 2010 Code Example: Creating PivotTable Reports and Charts with VBA

You can use VBA code to create PivotTable reports and charts repeatedly and efficiently. The VBA example in this download accompanies the technical article "Creating PivotTable Reports and Charts with VBA in Excel 2010." System Requirements: This download works with the f

 
 
 
 
 
3.8 Star
(16)
30,141 times
Add to favorites
Office
6/3/2011
E-mail Twitter del.icio.us Digg Facebook
Sign in to ask a question


  • ActiveSheet Add-in XLA
    2 Posts | Last post December 15, 2013
    • If I save the file as xla and use i as an add-in,
      I get runtime error 91 object variable or With block variable not set
      What should I changed ActiveSheet. into so that it reference the object properly?
      Any object reference with ActiveSheet. produces this error 91.
    • look here http://msdn.microsoft.com/en-us/library/aa264506%28v=vs.60%29.aspx
  • Multiplying he Result of xlSum
    6 Posts | Last post June 07, 2013
    • objField.Function = xlSum
      
      How can I create another column which calculates xlSum * 2 or Grand Total * 2?
    • I did NOT YOUR QUESTION
    • I did NOT YOUR QUESTION
    • I did NOT YOUR QUESTION
    • I did NOT YOUR QUESTION...
    • I did NOT YOUR QUESTION
  • Pivot Table
    1 Posts | Last post August 30, 2012
    • How to specify the name of the Pivot Worksheet in VBA that is created by Sheet1.PivotTableWizard?
  • How do I start the lesson?
    2 Posts | Last post March 06, 2012
    • Now that I've downloaded the workbook, what do I do? Just looking at the workbook isn't too helpful :) 
      
      I'm absolutely excited about the topic, but need help and want to follow along with a tutorial. 
    • The tutorial for this is located at http://msdn.microsoft.com/en-us/library/hh243933.aspx 
      
      you are supposed to read that and then come look at the code used in the tutorial. go to the developer tab and click the macros button. you can see all macros in the workbook. select the macro you want to study and click "step through" which allows you to see the code execute on the workbook line by line. press f8 to move to each new line of code. 
      
      if you do this while reading the article it should help you to follow what is happening.