Macro that will open another workbook, update the links, and close it

hi guys

i need a macro that when i click on, it will open another workbook named X for example, and update the links in that workbook and then close and save the changes

is it possible ?

It should be possible.

Try recording a macro as you go through the actions of opening, updating etc.

Once that is done if you require any further assistance with the macro post a copy of the code and list details of what is required