Hi

I would like to use Excel as a interface for writing values to our budgeting cube. I am using examples from www.mosha.com and microsoft KB. The interface is working fine with Office XP but when I use the writeback sheet on office 2000 I get compile error "user-type not defined". I've investigated the project references and I guess the problem is there. In fact I was getting the same error on Office XP until I ve included ADO 2.8 library in the project. I ve included ADO 2.8 also in Office 2000 and I get the same error.

Project references used on Office X
1.VB
2.Excel 10 object librar
3.Office 10 object librar
4.Microsoft ActiveX Data Objects 2.
5.OLE Automatio

Project references used on Office 200
Excel 9.0 object librar
Office 9.0 object librar
Rest is the same as on XP machine

Here is the piece of code on which I get the error: (whole macro can be found at www.mosha.com

Sub Writeback(pcell As PivotCell, newval As Double)

Thanks in advance for your suggestion

Jura