I am generating a series of workbooks from an access database and before the
code loops to the next record set I am trying to build a pivot table in each
one.

When stepping thru the code fails:

ActiveWorkbook.PivotCaches.Add("SourceType:=xlData base, SourceData:=
qdf.name!R1C1:R91C11").CreatePivotTable TableDestination:="", TableName:= _
"PivotTable1", DefaultVersion:=xlPivotTableVersion10


qdf.name is the variable name given to the query from which the workbook is
generated and the name of the worksheet with the data.

I believe the hangup is in how I am trying to pass that variable through to
all the workbooks.

Any help is appreciated

Thanks in advance


--
Jeff C
Live Well .. Be Happy In All You Do