Compiler won't accept "Excel.Application"

[GeorgeJ]

I am trying to practice transferring data between Access 2013 and Excel 2013.

I have the following code:
Sub Test04()
‘Line below copied from VBA 2007 Programming Bible
Dim AppExcel As Excel.Application
End Sub

Whenever I try to compile it I get an error saying “User defined type not defined”
What do I need to add to my file to get it to accept this declaration?



Thanks in advance

[orange]

You need a reference to Excel 2013

see this as example

[GeorgeJ]

Thanks. That works. The reference to Excel in the reference window was
Microsoft Excel 15.0 Object Library

[orange]

Good stuff!
Glad you have it resolved.