Excel Application as VBA Object

  • Thread starter Thread starter Dan
  • Start date Start date
D

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
 
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.
 
Back
Top