View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Mike Waldron Mike Waldron is offline
external usenet poster
 
Posts: 7
Default 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/

.