word document with embedded spreadsheet linkiing field problem

[ATTACH=CONFIG]40332[/ATTACH]

Hi

I have been having a problem with an embedded spreadsheet in a word document. Most of yesterday was spent fixing a problem where the spreadsheet would change to a picture and become uneditable (fixed by copying office registry entries from another computer) but that's another story.

I have been trying to link a field to a cell but after creation I cannot get it to update. The link becomes broken. I have followed some instructions I found in this post http://www.vbaexpress.com/forum/showthread.php?t=376 but to no avail.
If somebody could tell me what I'm doing wrong I would be extremely thankful, I'm close to giving up on it and leaving it to be done manually.

Thanks
Pads

Re: word document with embedded spreadsheet linkiing field problem

nobody knows then??

Re: word document with embedded spreadsheet linkiing field problem

Thanks ZappAstrim.
Is this the script you refer to http://www.ozgrid.com/forum/sh…57163&p=573018#post573018 ?
I'm a bit up to my ears at the moment but will give it a go in a couple of days.

Cheers
P

Re: word document with embedded spreadsheet linkiing field problem

Finally had a bit of time to look into this some more today but haven't got anywhere with it.
I have inserted your code into the embedded excel sheet. The cell is named TOTAL and the bookmark in the word file is also called TOTAL but its not updating.
I'm sure I am getting something fundamental wrong.

If you do have some spare time I'd appreciate it if you could have a look, if not not to worry looks like i'll just have to use the good old reliable copy and paste.

Many thanks
Patrick

file needs renaming to Invoice For Professional Services.dotm