How to declare a variable as an excel worksheet in vba

[almaroc]

i am using access 2007 and i am trying to read data directly from a spreadsheet. i am running into this error User defined object not defined. i am declaring the variable as follow
dim Mywb as workbook
dim Myws as worksheet

[Rabbit]

Assuming you've included the reference to the Excel library, you need to qualify it using Excel.. Meaning you need to use Excel.Workbook

[almaroc]

Thanks Rabbit that took care of it. i really appreciate it.