We have a problem with a couple of word-docs that links (merge function) to
an excel-file that used to be on one server, but now is on another server.
We would like to *change* the path to the excel file in some smooth way (not
by doing it manually, it's like 800 documents).
Any ideas here? We tried a vb-app that uses the application-object, opens up
word looks at the path and then changes it, it *seems* to work *but* for
every word document, excel opens up and you have to confirm everything
through a dialog box. A little tedious do manually confirm like 800
docs...:/
Any way around this (automatic confirm, not opening the dialog box, another
solution, anything)?
All input appreciated.
Regards,
/e
Word Heretic - 05 Dec 2004 00:58 GMT
G'day "Eric" <eric@hotmail.com>,
There is sample batch code in http://word.mvps.org/FAQs/index.htm
Steve Hudson - Word Heretic
steve from wordheretic.com (Email replies require payment)
Without prejudice
Eric reckoned:
>We have a problem with a couple of word-docs that links (merge function) to
>an excel-file that used to be on one server, but now is on another server.
[quoted text clipped - 14 lines]
>Regards,
>/e