Excel.Application error

[brum_rich]

I am trying to link data from Access to Excel. I am using the following code to declare the Excel application.

Dim myXL As Excel.Application
Dim myWkb As Excel.Workbook
Dim mySht As Excel.Worksheet

When I run the code I get a compile error stating user defined type not defined. I have used this code before in other programs. What am I doing wrong?

 

[Bodisathva]

check your references...most probably you are missing the Excel Object Library