on the VBA window, go the the Tools menu and choose References.
In that dialog, scroll down to and check the entry for Microsoft Visual Basic For Applications Extensibility 5.3.
If you do not set this reference, you will receive a User-defined type not defined compiler error.

--
isabelle



Le 2012-05-05 17:01, John a écrit :
Isabelle,

a réf. for Microsoft Visual Basic For Applications Extensibility 5.3

I have no idea what that is! Guess I need to do a little mroe
research.


On May 5, 2:54 pm, wrote:
hi John,

did you added a réf. for Microsoft Visual Basic For Applications Extensibility 5.3

================================================== =========================*======================== =============
•First, you need to set an reference to the VBA Extensibililty library.
The library contains the definitions of the objects that make up the VBProject.
In the VBA editor, go the the Tools menu and choose References.
In that dialog, scroll down to and check the entry for Microsoft Visual Basic For Applications Extensibility 5.3.
If you do not set this reference, you will receive a User-defined type not defined compiler error.
================================================== =========================*======================== =============