Hi,

I am writing a VB program to creat PivotTables and Charts. The source data
is in a Excel file and the output with pivot tables and charts should be
stored in another excel file. My code fails in the following command

oWorkBookOut.PivotCaches.Add(xlDatabase,
"'dec'!R1C1:R179C20").CreatePivotTable oWorkSheetOut.Range("A3"),
PivotTableName

I am getting a "Application-defined error or object-defined error"

I am using VB 6.0 with SP6 and Office 2000 with SP3.

This code works well in Win XP and Office 2003.

Please help

Cheers,
Vijay