If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.

Updating Links, Ignore workbooks that are open

Thread starter chris186h
Start date Jul 1, 2015
Tags

update links vba workbook open

chris186h

Board Regular

Jul 1, 2015

Hello all. In my workbook i have a button to update the workbook which i will press several times whilst it is open as the files regally change. It all works well unless i have one of the workbooks open. Is there a way for vba to check to see if the workbook is open, if so then it will skip the update and then move onto the next update.
I am currently getting an error if the workbook is already open so i am trying to avoid this
Thankyou for your help

Code:

 ActiveWorkbook.UpdateLink Name:="K:\Plan.xlsx", Type:= _        xlExcelLinks
        ActiveWorkbook.UpdateLink Name:="K:\Earlies.xlsm", Type:= _
        xlExcelLinks
    ActiveWorkbook.UpdateLink Name:="K:\Lates.xls", Type _
        :=xlExcelLinks
    ActiveWorkbook.UpdateLink Name:="K:\Nights.xls", _
        Type:=xlExcelLinks
    ActiveWorkbook.UpdateLink Name:="K:\Rota.xlsm", _
        Type:=xlExcelLinks