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

[aytee111]

In VBA editor - Tools>References, add the Excel object library.

[pbaldy]

Alternatively, particularly if you could have users with different Excel versions, use late binding:

http://support.microsoft.com/kb/245115

If everybody will have the same version you do, early binding is probably easier and aytee's answer is the way to go.