Excel 97 and Excel 2000 compatibility problem

[shep6]

I have recorded a macro in Excel 2000 which creates a pivot table, this runs fine in Excel 2000, but when I run it in Excel 97 I receive the error message "Object doesn't support this method" on the following line:

ActiveWorkbook.PivotCaches.Add(SourceType:=xlDatabase, SourceData:= _
"'Boots Query 1'!R1C1:R90C7&quot.CreatePivotTable TableDestination:="", _
TableName:="PivotTable1"

I guessing it's because 97 doesn't support the Add method. Does anyone know the code I need to use to make it work in Excel 97.

thanks

 

[ilses]

This was answered in the VBA forum by Store300.