Linking To Excel Graphs
 

I have a workbook with a worksheet that contains multiple graphs. I need to
create OLE links to each graph and display the in object frames in a MS Access
database. It seems that I need to be able to refer to each graph in the
"language of Excel". I need a way to express the path to the worksheet not just
the workbook and then I need a way to refer to a specific graph on the
worksheet. I have found a reference to Excel's ProgID object identifier but
that's all I have. At this point, all that I have been able to do is display the
whole worksheet so I get all the graphs as well as the spreadsheet rather than
just a graph. Can anyone help me out here.

Thanks!

Steve

Linking To Excel Graphs
 

See the response in .charting.

--
Regards,

Tushar Mehta (www.tushar-mehta.com) MS MVP -- Excel

In article ink.net,
says...
I have a workbook with a worksheet that contains multiple graphs. I need to
create OLE links to each graph and display the in object frames in a MS Access
database. It seems that I need to be able to refer to each graph in the
"language of Excel". I need a way to express the path to the worksheet not just
the workbook and then I need a way to refer to a specific graph on the
worksheet. I have found a reference to Excel's ProgID object identifier but
that's all I have. At this point, all that I have been able to do is display the
whole worksheet so I get all the graphs as well as the spreadsheet rather than
just a graph. Can anyone help me out here.

Thanks!

Steve