Excel Application as VBA Object

[Dan]

I have imported a vba module into a new database however
the code will not run because when it gets to the line:

Dim objxl As Excel.Application

I get this
Compile error:
User defined type not defined

Does anybody Know what the problem is, the code works fin
on the other database with this

 

[Van T. Dinh]

You need to add the Excel Object Library into the References Collection of
your database.

Open any code module and use the Menu Tools / References ... to get the
Reference dialog.