Word to Excel links

[CAE1030]

I have a C# application that creates linked word-excel pairs.
How can I (from a macro, VB or C#) remove "automatically" the links before
saving the documents? The links go from Word (destination) to Excel (source)
graphs.

 

[Cindy M -WordMVP-]

Hi =?Utf-8?B?Q0FFMTAzMA==?=,

I have a C# application that creates linked word-excel pairs.
How can I (from a macro, VB or C#) remove "automatically" the links before
saving the documents? The links go from Word (destination) to Excel (source)
graphs.

Remove just the links, leaving the Excel stuff as embedded objects?

Are these graphically "in-line" with the text or do they have text-wrap
formatting? And which version of Word?

Note: You've posted in an end-user group. The better place to get help with
developer questions would be an office.developer or word.vba newsgroup (you just
have to be careful to phrase the question to avoid scaring people off with
".NET").

Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update Jun 8 2004)
http://www.word.mvps.org

This reply is posted in the Newsgroup; please post any follow question or reply
in the newsgroup and not by e-mail

 

[CAE1030]

I found the problem when, as End User, I was unable to create a macro to
break the links. After recording the macro, the macro content was empty, and
the macro execution did not break the links.
I wanted to keep the graphs (e.g. as if they were pasted in the Word or
Powerpoint document). The graphs are independent of any text (e.g. thet are
on a page of their own).
I am using Word 2003, but I believe this is true for all versions of Word.

I tried to do the same (as .Net developer) from C#, with the same results.

Is there a way to create a macro to break links? (Excel macro, VB, VB.net
or C#)

 

[Cindy M -WordMVP-]

Hi =?Utf-8?B?Q0FFMTAzMA==?=,

Is there a way to create a macro to break links? (Excel macro, VB, VB.net
or C#)

there is, but you have to answer my question:

Are these graph objects inserted in-line with the text, or with text wrap
foramtting? (It makes absolutely no difference whether you think they're on a
page of their own (they aren't, at least one paragraph is on that page).)
When you click on these do they have black handles, or white ones?

Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update Jun 8 2004)
http://www.word.mvps.org

This reply is posted in the Newsgroup; please post any follow question or
reply in the newsgroup and not by e-mail