updatelinks function doesn't work correctly

[rnl0085]

while it was always working, at some day it didn't anymore. using the updatelinks function in a macro, with that other file open at the same or a different pc, the macro that only uses the Worksheetfunction Updatelinks with a correct reference to the file but still vba crashes/gives an error.

somewhere i read that it might be caused because the file is open, but it always did work correctly.

 

[Andrew Poulsom]

Please post the code you are using and tell us what error you are getting.

 

[rnl0085]

The error i get is:

Runtime error 1004
Method 'UpdateLink' of object '_Workbook' failed

the code is

Public Sub Data()

Activeworkbook.Updatelink name:="K:\folder\filename.xls" Type:=xlExcelLinks

End sub

 

[Andrew Poulsom]

If the source workbook is open you only need the filename not the entire path. There is some code here that updates all Excel links:

http://www.mrexcel.com/forum/showthread.php?t=70870

 

[rnl0085]

It is open, but sometimes it is open at another computer (and that also gives the error, and the file from which to update the links isn't in the same directory as the file that uses the macro). But if it's open on the same computer, that causes the error then for sure on that computer?

 

[Andrew Poulsom]

If you try to update the links manually what happens?

 

[rnl0085]

how can i do that? cause i want only the links to that file to be updated and not all the links in the workbook

 

[Andrew Poulsom]

Choose Edit|Links select the workbook and click Update Values.

 

[rnl0085]

then it shows the normal 'open file' window (at c:\my documents\)
when i then go to the correct destination it actually works...but that destination link is already correct in the edit links overview..

 

[Andrew Poulsom]

Sorry, I don't understand what you mean by "'open file' window". Pressing Update Values shouldn't require that you open a file.