OLE objects

[Steve]

Hi,

Right guys, I have a form that the user can use to link to
a spreadsheet and update records within the DB.

The spreadsheets can contain any amount of
worksheets/rows/columns. 1 Column must contain the
reference needed to relate back to the DB.

So, what I want to do is;

1. Give the user the option to choose the spreadsheet.
2. Open the spreadsheet as an OLE object.
3. Get the user to select the Worksheet where the updates
are to come from.
4. Get the user to select the Column where the Reference
is.
5. Use code to link to the spreadsheet and run a query on
it.

I have options 1 and 5 covered, its just the OLE bit I
cant understand.

Can anyone help me please?

Cheers,
Steve.

..