Thanks for your help.
The links in my word document are all set to be updated manually. I just
want them to be updated when the MACRO is launched. However, I tried
unchecking the box "Update automatic links at open", as I figured out it
wouldn't apply to my program, and surprisingly enough the MACRO runs a little
Anyway, isn't there a way of telling word (using vba) to open just once my
excel source file, update all links in the word document and then close the
excel file? I guess that would save a lot of time compared to opening /
closing the same file for each link.
I guess there must be a workaround, I cannot be the first person willing to
update many excel links in a word document using vba without having to wait
for more than 10 min.