I created a Microsoft Word document that contains dozens of linked Excel
worksheets. I am searching for a method to programmatically search and
replace all these links.

In searching online, I found code to perform this task for both Access and
PPT ... but not for MS Word.

I have also found a program called "ReplaceMagic," but I need this solution
for the workplace and they'll never let me download third-party software for
this. I need some Visual Basic code.

Here are the solutions I discovered for Access and PPT, available on the
Microsoft website:

Access: "ACC2000: How to Programmatically Link or Embed an Object on a Form
(Article ID 209990)"

PowerPoint: "PPT2000: Sample Code to Change Source of Linked Excel Worksheet
(Article ID 222708)"

If anyone has a solution for Word, I'd really appreciate it!

You might be better off posting this in a Word group, this one is for
Outlook.

--
Ken Slovak
[MVP - Outlook]
http://www.slovaktech.com
Author: Professional Programming Outlook 2007
Reminder Manager, Extended Reminders, Attachment Options
http://www.slovaktech.com/products.htm


"Oli" <(E-Mail Removed)> wrote in message
news:B12AA8EC-BCC3-4469-8B8C-(E-Mail Removed)...
>I created a Microsoft Word document that contains dozens of linked Excel
> worksheets. I am searching for a method to programmatically search and
> replace all these links.
>
> In searching online, I found code to perform this task for both Access and
> PPT ... but not for MS Word.
>
> I have also found a program called "ReplaceMagic," but I need this
> solution
> for the workplace and they'll never let me download third-party software
> for
> this. I need some Visual Basic code.
>
> Here are the solutions I discovered for Access and PPT, available on the
> Microsoft website:
>
> Access: "ACC2000: How to Programmatically Link or Embed an Object on a
> Form
> (Article ID 209990)"
>
> PowerPoint: "PPT2000: Sample Code to Change Source of Linked Excel
> Worksheet
> (Article ID 222708)"
>
> If anyone has a solution for Word, I'd really appreciate it!
>