Linking Excel cell to specific section in Word using macro

Hi,

I've only just joined, but I have been browsing through the site previously and found it very helpful. I'm wondering if anyone on here could help or try steer me in the right direction with an issue.

I'm looking to link an excel sheet with a word document, the document is a template with certain specific parts that are required to be filled in. Here's a quick example:

Book 1 contains a certain stress value in cell A1, let's say 0.89

In the word document, I have a line such as "The maximum stress value is ____"

I have found different codes online but they only seem to create a new document, while I want to use a spreadsheet to fill in certain parts of an existing word document. I have tried using "Paste Link" but it keeps breaking the links when the two files are moved or copied to a new folder, the link will always try to find the original.

Can anyone help me on this problem??

Hi,

you must first create a bookmark in the Word document …

Originally Posted by Marc L

Hi,

you must first create a bookmark in the Word document …

Once I do that, how can I connect that to a cell on excel? And also keep the link saved if the files get moved from folder to folder

No need to quote the previous message !

No link if both files are saved in the same path …
So once workbook is opened, you already know where the word document is stored !
A workbook macro pilot Word and use the document bookmark to fill data …

You can also do the opposite : within a Word document macro to pilot Excel …

Ok thanks, but if I have around 10 bookmarks in my word document. What can I code into excel to fill those bookmarks in? But also allow the two files to change folder path?

See Path property in Excel VBA help !

One Word bookmark name = one Excel cell name.
If it's the same names with numbers at end, you even could use a loop …

Ok I'll look at that,thanks for your help!

Ok I'll have a look at that, thanks for your help!