Update links between Word and Excel using VBA

[mfd]

I have approximately 30 microsoft word 97 documents containing linked Excel 97 charts. Most users have read only access to the information and therefore the linked charts are locked to avoid unneccessary error messages. I want to write a VBA macro that will open the 30 or so word documents, unlock the links, update the excel charts (answering 'yes' to any questions like '..contains macros ...do you want to open..' or '..do you want to update information..') then lock the links and save the word documents. I am new to VBA and cannot find out the syntax required (and even if I could, I'm not sure it would work!).

Please help!!

 

[SkipVought]

Hi,

Try Macro Recording what you want to do for one link and then modify the code. Skip,
metzgsk@voughtaircraft.com

 

[mfd]

Recording a macro doesn't work. All you get is Sub Name()
End sub(). No script inbetween.