Copy Excel data to Word fields and retain fields

Thanks, snb. I tried .fields.unlink again, and this time it decided to work. Hmmm...

This has raised another issue or two, however. I see that doing that has also removed the fields from my Table of Contents (and probably page numbers) in my Word doc. I will need these later. So I tried to use your code (thanks) to see if I could just remove some of the fields, but I got the same error: "Variable not Defined" on "ActiveDocument". I am using Option Explicit in the code, and it's Office 2003.

Also, I have used ".activate" about six times in my code, and "select" once (just to put focus into a particular cell before the code finished running). What should I use instead? (One of those .activates is just before .fields.update .fields.unlink)

Originally Posted by snb

But why would you like to 'unlink' ?

One of the documents filled from VBA is the template of what will eventually be a large Word document. When filled from VBA, there is still a lot more work to do on the document. VBA only puts some helpful bits of information in there (names, addresses, correct pronouns, etc). After the document is completed, it gets formatted by admin staff. They have had trouble with other fields in documents - although these were a different type. The trouble has come when they want to modify something in one of the fields, and it breaks links to other fields in the document, and that causes errors. So I thought it would be best to remove DocVariables when it gets to that stage.

You've got me thinking now, though. I wonder if DocVariables would give the same trouble. I'd better do some experimenting... or just wait till the thing is up and running, and see what happens.

These documents are sometimes sent to clients as Word docs as well (rather than PDF). I wonder if there will be any issues there.

Now, about not using .activate in VBA...?