Manipulating Pivot Tables with VBA
 

I am trying to programatically create a pivot table with a tab delimited
data string. The fifth column of this string is the Value field with
numbers appearing in different formats or even text. I am creating this
pivot table by dropping the string on a sheet and using the Jet driver
to populate a record set which in turn populates the pivot cache. I
need to do it this way since I overshoot the 65000 row limit for Excel.
I can successfully create the pivot table if I eliminate all formats
and text values from column 5. I want to know if there is any way for a
pivot table to handle text based values and number formats.

Thanks.



------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~ View and post usenet messages directly from http://www.ExcelForum.com/

Manipulating Pivot Tables with VBA
 

Patriot301 -

The numbers shouldn't be a problem. You can format them
within the pivot table. Text is another matter. As far
as I know, there is no way to convert text to number
within the pivot table.

Mike
-----Original Message-----
I am trying to programatically create a pivot table with
a tab delimited
data string. The fifth column of this string is the Value
field with
numbers appearing in different formats or even text. I am
creating this
pivot table by dropping the string on a sheet and using
the Jet driver
to populate a record set which in turn populates the
pivot cache. I
need to do it this way since I overshoot the 65000 row
limit for Excel.
I can successfully create the pivot table if I eliminate
all formats
and text values from column 5. I want to know if there is
any way for a
pivot table to handle text based values and number
formats.

Thanks.



------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~ View and post usenet messages directly from
http://www.ExcelForum.com/

.