Sign in
 
Home20132010Other VersionsLibraryForumsGallery

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,422 times
Add to favorites
Office
6/4/2011
E-mail Twitter del.icio.us Digg Facebook
Report abuse to Microsoft
Sign in to ask a question

  • Answer the question | Hide
    ActiveSheet Add-in XLA
    2 Posts | Last post December 15, 2013
    • Written August 30, 2012 
      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.
    • Written December 15, 2013 
      look here http://msdn.microsoft.com/en-us/library/aa264506%28v=vs.60%29.aspx
  • Answer the question | Hide
    Multiplying he Result of xlSum
    6 Posts | Last post June 07, 2013
    • Written August 30, 2012 
      objField.Function = xlSum

How can I create another column which calculates xlSum * 2 or Grand Total * 2?
    • Written June 07, 2013 
      I did NOT YOUR QUESTION
    • Written June 07, 2013 
      I did NOT YOUR QUESTION
    • Written June 07, 2013 
      I did NOT YOUR QUESTION
    • Written June 07, 2013 
      I did NOT YOUR QUESTION...
    • Written June 07, 2013 
      I did NOT YOUR QUESTION
  • Answer the question | Hide
    Pivot Table
    1 Posts | Last post August 30, 2012
    • Written August 30, 2012 
      How to specify the name of the Pivot Worksheet in VBA that is created by Sheet1.PivotTableWizard?
  • Answer the question | Hide
    How do I start the lesson?
    2 Posts | Last post March 06, 2012
    • Written February 15, 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.
    • Written March 06, 2012 
      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.