Hi,
I have two separate Excel workbooks. The first contains data from an OPC server and the second is linked to first workbook via cell links. For example:
='H:\Engineering\Data I4\[DataI4.xlsm]Sheet1'!C7
In order to keep the data current I am doing the following:
In the first workbook I am saving the file at regular intervals so that the links in the second workbook are accessing the latest data. In the second workbook I am updating the links using the following code:
ActiveWorkbook.UpdateLink Name:=ActiveWorkbook.LinkSources, Type:=xlExcelLinks
However every now and again the first workbook faults with an error saying the file can’t perform the save.
I am thinking that the first workbook is trying to save at the same time as the update is happening in the second workbook. This clash that is causing the error message.
Can anyone suggest a way to overcome this?
Thank you.
Bookmarks