Thanks that works but updating all the links however is it possible :
1. For the user to define the path (i.e select the file from a prompt screen as the file link changes on a regular basis).
2. Update the links once the marco is run. (currently i have to manully click on "Update Now" button)