Access to Excel

[Rick West]

I have 2 databases. I'll call "A" and "B".

Database "A" has code that works so I copied it into database "B" and it does not work.

The code line that is getting hung up in database B is "Dim wb As Workbook". Database B error is "User-defined type not defined". So I looked back in database A to see if I could find where they defined an excel workbook as a type - not there.

What am I doing wrong?

[aytee111]

In the VBA editor, go to Tools>References and add the Microsoft Excel reference

[Rick West]

You guys are the best.

Keep it up please as we users really appreaciate the help.