Excel activex control?

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

Instead of embed excel into a form why not to automate excel from vb6
The next link could help you a lot --->
http://www.vbforums.com/showthread.php?t=391665

you can embed an excel workbook in an ole contaier
add the ole to your form, from the toolbox

not to say i would recommend this method

Quote:

---

Originally Posted by jggtz

Instead of embed excel into a form why not to automate excel from vb6
The next link could help you a lot --->
http://www.vbforums.com/showthread.php?t=391665

---

Thanks for the suggestion... I am already familiar with creating/opening/reading/writing using Excel from within Vb. I was looking for something that gave the freedom of an excel spreadsheet but can also work with the program. Certain fields from the program would link to the spreadsheet and the spreadsheet would need to be automatically updated if the numbers within the program changed.

Quote:

---

Originally Posted by westconn1

you can embed an excel workbook in an ole contaier
add the ole to your form, from the toolbox

not to say i would recommend this method

---

I did see this but I have no idea how to use it. Why would you not recommend it?

try it for yourself!!

i checked into that method a few yrs ago and i think i did not go that route
because it made my downloaded a lot bigger. I think that was the reason