Hi,

I am trying to pass a String of SQL code into
Pivotcache(1).CommandText = Array (...., ..., ..., etc)

I keep getting the error message: Run-time error '1004' Application-defined
or object error. clicking Help doesn't tell me anything.

I have successfully passed SQL into the CommandText before, I thought I got
it to work by limiting the length of each element of the array...

When I take the SQL I am trying to pass in to the CommandText and paste it
directly into MS Query behind the PivotTable it works fine. so I know the SQL
code is valid.

Ideas?

Thanks

Simon Shaw