Compile error: User-defined type not defined

[KentaH]

Hi all,

I have a classical problem that have been up to discussions in many forums. Believe me, I have visited if not all of them then at least a large portion of them.

My task is pretty straight forward I guess. I need to fill some cells with document properties so I start with this:

Dim properties As Microsoft.Office.Core.DocumentProperties

I want it to happen in a Workbook_Open().

I have tried every possible reference library such as: Microsoft Forms 2.0 Object Library, Microsoft ActiveX Data Objects 6.1 Library....but I always get the same message box :banghead:

Please I'm stuck and I really need to get this going.

I use Microsoft Excel 2010

Regards
Kennet

 

[jdraw]

Kennet,

You have posted in an MSAccess forum. You have mentioned Excel, workbook and cells which are not part of Access.
You have not mentioned/described the problem in any detail.

I suggest you show a jpg (screen capture) of the failing code highlighting the error.