Working with OLE excel charts in Access 2010

[snoopy2003]

Hello,

I need to add excel charts to my access application.


I added them as ole objects.

How can I connect using VBA to this ole objects worksheet
(in order to update charts data) ?

Thank you for your help

[snoopy2003]

Hello,

I have managed to open the excel ole from within access.

I have an opened access database & excel workbook.

How can I connect to the open workbook from within access by using VBA ?

Thank you for your help