Can somebody advise me on where to find info and examples on using, referencing the Microsoft Office Spreadsheet activex tool on a form in access?

Questions like 'how to reference the cells thru the access vba', 'to what extent can I use known excel vba language to duplicate activities that I have already done in Excel'...

I am a good access and excel programmer but I don't know how to use this resource..

Thankyou

I searched around and Wrox doesn't have any books that deal with this control. I found these articles at Microsoft that might help:

Understanding the Spreadsheet Control
http://msdn.microsoft.com/en-us/library/aa141361.aspx

Using Microsoft Access to Create a Spreadsheet Control
http://msdn.microsoft.com/en-us/library/aa141371(office.10).aspx

Working with the Spreadsheet Component's Object Model
http://msdn.microsoft.com/en-us/library/aa141595(office.10).aspx

Did any of those help?


mmcdonal

Look it up at: http://wrox.books24x7.com