My VBA project opens 4 seperate XL application objects and between them about 12 huge workbook objects are openned. Sounds crazy doesn't it. All of the workbooks are linked to atleast one other workbook.
Any way I cant seem to get the updatelink method to work once the workbook/s are open.
I have changed the syntax of this statement several times and checked it against the help and i know its correct.
The problem lies elsewhere ??
The links are successfully updated when the workbooks are opened.
ap(0).Workbooks.Open sourcedir & "FX 330 (T-1)&(T-1)2.xls", True
I just need to be able to update the links once the sheets are open. The error message i get is
runtime error 1004
Method 'UpdateLink' of object '_Workbook' failed
Some thing that gave me a clue was :
when i into the edit>links menu in Excel the update now button is grayed out. This button is greyed out for all the links that are to xvl files that are currently open.
any ideas ??