I want to show an excel-graphs in one of my access-forms.
The problem is how to refer to an embedded excel-file in my form.
I can refer to an external excelfile (see below) an do some test stuff
in this file but how can I do the same thing in an embedded Xls-file
like "Forms![frmTestForm]![OLEUnbound77]" ?

How about using Microsoft Graph, available in reports for Access? Ah,
you ask for form functionality.

Apart from answers you get here, try an Excel group as well (don't
mention Access there ;-) )
You want to control Excel through its own VBA dialact, I am afraid.

veens-zevenhonderdvijf wrote:

Hi,

I want to show an excel-graphs in one of my access-forms. The problem is how to refer to an embedded excel-file in my form. I can refer to an external excelfile (see below) an do some test stuff in this file but how can I do the same thing in an embedded Xls-file like "Forms![frmTestForm]![OLEUnbound77]" ?