word merge dox problem

[Eric]

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]

G'day "Eric" <[email protected]>,

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: