code not working

  • Thread starter Thread starter eric
  • Start date Start date
E

eric

I don't think my previous message was posted

My VBA code doesn't seem to work when I try to run it.

Private Sub equipexport_Click()
Dim oXL As Excel.Application
Dim oWkb As Excel.Workbook
Dim oWks As Excel.Worksheet
Dim rstSubForm As DAO.Recordset
Dim iRow As Integer

It says "Compile error User-defined type not defined" and
then it points to the second line (Dim oXL As
Excel.Application)

Thank you in advance
 
Hi,



If you don't run this code in Excel, you need a reference to the library.



Go to Tools > References and add the proper references "Microsoft Excel 10.
lib"
 
Yes. It was posted and answered which was:

Have you added the Excel Object Library and the DAO 3.6
Library into the References Collection of your database?

HTH
Van T. Dinh
MVP (Access)
 
Back
Top