How can I programmatically relink my linked Excel worksheets

Oli · Joined: 04 Oct 2007 Posts: 2

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!

Archived from group: microsoft>public>vb>directx

Newbie: Linked Cubes... Hello, I'm appealing for some help from a generous person! Is there anyone who can provide me with an example of how to draw 2 cubes in VB6/DirectX 8 with a line joining them? I'm really struggling with this. Note least because I don't understand vertic

2003 Excel Spreadsheet with a VBN file wont run with Excel 2 i have a spreadsheet the i've used for many years which auto login to 8 different sites automatically buy putting my username and pass word into a browser window so that i dont have to manually enter the username and password and than download the informa

Excel VBA File Search and scheduled task Hi I have a macro to unzip the file in a directory. The macro will check whether the zip file has already been unzipped. If not, the macro will check whether the zip file is in the directory. If the zip file is not available, the macro will stop, other

Office 2007 Professional Excel is not for commercial use? I want to sell spreadsheets I create in Excel 2007. How can I do that? What additional software package must I purchase? Visual Studio or what? -- TomThumb

Runtime error when trying to save Excel 2000 worksheet from I have a VB 6.0 application that creates reports using Excel 2000. The application has been working fine but recently I installed it on a new hard drive (same and now I get a run time error every time I try to save the excel report. The e