You are right Robert. When user don't mention their excel version. We
can not go back to old version unless specified. This code works on
both 2007 and 2010.
Thanks & Regards
Ashish Jain
(Microsoft Certified Application Specialist)
(Microsoft Certified Pro
hi Ashish,
there are some differences in methods between 2003 and 2007 versions.
The method Create of PivotCaches is not present into 2003 version and
replaces the method Add.
regards
r
2010/11/24 OpenExcel.com
> HI Raj,
>
> You can use the below mention code:
> Focus on arguments and understa
HI Raj,
You can use the below mention code:
Focus on arguments and understand them, it's easy, you'll never
forget.
ThisWorkbook.PivotCaches.Create(SourceType:=xlDatabase, _
SourceData:="Sheet2!R2C2:R6C6", _
Version:=xlPivotTableVersion12).CreatePivotTable _
TableDestination:=