PivotCache.CommandText - string length limitation in Excel 2000???

C

corndog

In Excel 2000, if the string length of pivotcache.commandtext is greater than 255 then "VBA error: 1004, Application-defined or object-defined error". In Excel 2002 this error doesn't occur. Can you confirm this is a limitation on Excel 2000?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

PivotCache.CommandText - string length limitation in Excel 2000??? 0
Working outlook via vba code with xlsx - error 0
Closing PDF file from Excel VBA (Adobe Reader, Adobe Acrobat, Browser) 0
PivotFilters in pivottable 0
Code OK in XL2003 but Run-time error '1004' in xl2007 0
Excel 2007 - Dynamic sheet naming 1
Creating an Excel Pivot Table using COM in C# producing 0x800A03EC 0
VBA Assigning cell value to variable giving runtime error 3

Top