I am creating a program with an access database and a vb6 front end.

I need to know if there is a way to embed an excel spreadsheet into a form and "link" a cell defined by the user to a text box in the program.

It has to be dynamic because the spreadsheets will be used by the accountants to show how they came up with calculations. Also, the "link" will need to automatically update the spreadsheet if the numbers in the program change.

Any suggestions would be greatly appreciated. I tried searching on line but haven't come across what I am looking for.

Thank you.
Chrissy