Use Excel in Access

[Eric]

Hi , i try to use Excel worksheet in a access database.
I try to use Excel.application to get my excel worksheet
but i receive this errors at this line.

Errors :
Compile errors :
User-defined type not define

Line :
Dim xls As Excel.Application


I found this example in the help of Excel ... What the
problem ???

 

[Kristyn Wagoner [MSFT]]

Hi Eric -

Make sure that you have a reference set to the Excel Object Library.

1. Hit Alt+F11 to go into a VB Module.
2. Click Tools--->References
3. Make sure that Excel Object Library is checked.

Take a look at this article for more information.

202192 ACC2000: "User-defined Type Not Defined" Error Message
http://support.microsoft.com/?id=202192

Hope that helps!!

--
Kristyn Wagoner
Microsoft PSS

Please do not reply directly to this alias. This alias is for newsgroup
purposes only.

This posting is provided "AS IS" with no warranties, and confers no rights.