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)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

My code isn't working 2
Inserting Row in an Excel Table 1
method 'add' of object 'workbooks' failed 3
Manipulating Excel through Access 4
COM interop XL2000 vs 2003 3
VB Workbooks.Add method will not work from my MS Access 2007. 2
What am I doing wrong? 3
can't compile, user defined type not defined 2

Back
Top