ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   How to get the PivotCell object?? (https://www.excelbanter.com/excel-programming/271577-how-get-pivotcell-object.html)

george

How to get the PivotCell object??
 
I am trying to run the ExtendingOLAP.xls that I downloaded
from MSDN http://msdn.microsoft.com/library/default.asp?
url=/library/en-us/dnexcl2k2/html/odc_xlextendolap.asp

but I keep on getting error "User-defined type not
defined" on the following statement: "Dim pcell As
PivotCell".

I understand the PivotCell should be part of the Office
Web Components (OWC).

I have installed Office SR1 and applied SP3, it still
doesn't work. I found no place on MSDN that tells me how
to verify that OWC are installed, or how to download them.

What do I need to do to get the PivotCell object?


All times are GMT +1. The time now is 12:12 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com