I have an application that manages Excel - word document pairs with Excel graphs linked from Word/powerpoint.
How can I (from C# or VB) break (manage) the links
I tried to record a macro to remove all links, but the generated macro is empty.
Office graphs links
Hot Topic
- Reliable Transactions.....
- Chart X Axis
- web access..
- Why can I not call FindControl on a toolbar object
- Debug JScript in an ASP.NET app with Visual Studio 2005
- VS 2003 Help System
- Getting contact information from Outlook and Exchange without security message?
- Does Microsoft Office InfoPath 2003 Toolkit for Visual Studio 2005 available to download?
- Stopping a TextBox resizing to infinity and beyond
- Bug Caching Non-DataSet objects in ServerDocument???
Visual Studio
- JavaScript Editor
- ASPNETCompiler Error - System.Web.AspNetHostingPermission, System
- How to thicken the lines in line-chart?
- svg + xaml
- difference between cr 8.5 and cr 11
- Inserted CD...waited...nothing happend! VS2005 Install
- VSTO 2003 and VSTO 2005 on the same machine?
- Toolbox Images no longer showing up transparent
- Error on Visual Studio Tools for Office "v3" install
- How to get IErrorHandler to work
Office graphs links
MichelleK
However, the method is not available for PowerPoint (in LinkFormat or OLEFormat).
Is there another way.
Thanks
Mosawi
Embedded Excel charts in a Word document are accessible in the Word object model via the InlineShapes or Shapes collection off of the Document object. Each chart embedded in Word is represented by an InlineShape if the chart is inline with the Word text or as a Shape if the chart is using another wrapping style (accessed by right clicking on the chart, choosing Format Object, and looking at the Layout tab).
You can access everything associated with that embedded chart via the OLEFormat property off of an InlineShape or Shape object. The OLEFormat object has properties that let you control and access the embedded chart object.
For documentation on OLEFormat see http://msdn2.microsoft.com/en-us/library/ms264354(en-US,VS.80).aspx
In PowerPoint, look for the Shapes collection off of the Slide object. A Shape object also has an OLEFormat property that returns an OLEFormat object that has properties that let you control and access the embedded Excel chart object.