Using Automation in Access

[Andy Kelly]

Does anyone know how I use VBA in Access to get Access to
start excel and open a workbook and select a certain
worksheet so that I can import a table from that worksheet?
I have tried using the "appexcel" function.
Excel starts in the back ground but I want to see the
workbook and worksheets I am telling it to open, cause i
keep getting errors when the code goes to open the xls
file.

Any help would be good.

andy