P
Pete
I have an Excel Add-in written in C# for Office 2003. It adds a
toolbar button that, when clicked, will pop up a dialog box with a few
controls on it, call a web service to get some stock exchange data,
and then write that data to a worksheet and create a chart.
In PowerPoint, on a slide with an Excel chart inserted into a
placeholder box, double-clicking the chart starts up Excel inside
PowerPoint. The toolbars are replaced and all the Excel functionality
is there, including my installed Add-in. If there is only one graph
on the slide, it works fine. However, if there is more than one graph
on the slide, all the automation (writing data, creating a table) will
only be applied to the first graph I double-clicked, even if it is not
the currently selected graph. In some way, when PowerPoint opens a
graph, it is opening an EXCEL.EXE process and using it for every
graph, but my Add-in is getting tied only to the instance of the
original graph.
Is there some way to force PowerPoint to release the Excel process and
start a new one every time a different graph is selected? Is there a
way my Add-in can tell which graph it is connected to, and change? I
have gotten as far as I can with my limited COM knowledge and this has
me stumped.
Thanks,
Pete
toolbar button that, when clicked, will pop up a dialog box with a few
controls on it, call a web service to get some stock exchange data,
and then write that data to a worksheet and create a chart.
In PowerPoint, on a slide with an Excel chart inserted into a
placeholder box, double-clicking the chart starts up Excel inside
PowerPoint. The toolbars are replaced and all the Excel functionality
is there, including my installed Add-in. If there is only one graph
on the slide, it works fine. However, if there is more than one graph
on the slide, all the automation (writing data, creating a table) will
only be applied to the first graph I double-clicked, even if it is not
the currently selected graph. In some way, when PowerPoint opens a
graph, it is opening an EXCEL.EXE process and using it for every
graph, but my Add-in is getting tied only to the instance of the
original graph.
Is there some way to force PowerPoint to release the Excel process and
start a new one every time a different graph is selected? Is there a
way my Add-in can tell which graph it is connected to, and change? I
have gotten as far as I can with my limited COM knowledge and this has
me stumped.
Thanks,
Pete