I am struggling to come to grips with creating a Pivot Table in Excel from VB. I have used the VB Macro to create the code but when I transfer this to VB.Net I cant get past where the pivot table outline 'which is created in Excel. I need a simple example if possible as all the sample code I have tried never works.