Using VBA to change the source of embedded links in Word

T

The Dow

I have a Word document that has hundreds of links to an Excel spreadsheet. I
need to change the source of those links. (All links will be the same, just
the location and filename will change.) I could do it manually, but it would
take forever. Is there a way to program it in VBA? There's got to be
something simple like
Activedocument.Fields(x).Changesource("c:\newfilename.doc"), right? Thanks.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Linking data in MS Word into Excel 5
Word VBA - Automatic change content of a cell in table using dropdown list 5
OLE link 0
Changing from linked to embedded Narrative on a Mac for Windows users. 0
Changing Source excel file causes links in word to fail 1
Avoiding Leads, using SVT, and Linking Tasks correctly 0
VBA code help for linking Word file to Excel file 7
Cross-reference Insert Default Change 0

Top