Hello,

I am using:
Visual Basic in .Net Framework 1.1
Excel reference: Microsoft Excel 11.0 Object Library

I recorded a VBA macro using Excel 2003 and replaced portions (workbook and range references... etc) as necessary.

But... the constants 'xlDatabase' and 'xlPivotTableVersion10' (please see code to create Pivotcache below) are shown as "not declared" in the .Net vb code.

Does anyone know if my reference is wrong or if I need to preface the constant somehow? I have searched the Object Browser for the Excel objects and I cannot find the constants so I think that I must have something out of sync between the Excel application I used to record the macro and the com reference used in the .Net application.

Thanks much.... Kim

Please Login or Register  to view this content.