#1   Report Post  
Posted to microsoft.public.word.docmanagement
CAE1030
 
Posts: n/a
Default Word to Excel links

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.
  #2   Report Post  
Posted to microsoft.public.word.docmanagement
Cindy M -WordMVP-
 
Posts: n/a
Default Word to Excel links

Hi ?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 :-)

  #3   Report Post  
Posted to microsoft.public.word.docmanagement
CAE1030
 
Posts: n/a
Default Word to Excel links

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-" wrote:

Hi ?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 :-)





  #4   Report Post  
Posted to microsoft.public.word.docmanagement
Cindy M -WordMVP-
 
Posts: n/a
Default Word to Excel links

Hi ?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 :-)

Reply
Thread Tools
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
How do I get rid of page numbers. The page number virus flamestar Microsoft Word Help 3 August 19th 05 02:31 AM
Does Word have Keyboard Merges like Word Perfect does? Donnas Mailmerge 1 June 28th 05 09:30 PM
Word2000 letterhead merge BAW Mailmerge 3 June 25th 05 01:17 PM
is word perfect compatible with office word? Noreen Microsoft Word Help 1 May 11th 05 11:17 PM
How do I create & merge specific data base & master documents? maggiev New Users 2 January 12th 05 11:30 PM


All times are GMT +1. The time now is 09:29 AM.

Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 Microsoft Office Word Forum - WordBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Word"