Word 97: Updating linked excel charts with 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!!