Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
When running this code in excel I am getting the following error:
Run-time error '1004': Method 'UpdateLink' of object '_Workbook' failed What's wrong? Here is the code I'm using: Sub UpdateSelectedLinks() Dim aLinks Dim cLink As String Dim i As Integer Application.ScreenUpdating = False aLinks = ActiveWorkbook.LinkSources(xlExcelLinks) If Not IsEmpty(aLinks) Then For i = 1 To UBound(aLinks) cLink = Split(aLinks(i), "\")(UBound(Split(aLinks(i), "\"))) If cLink < "MasterList.xls" Then ActiveWorkbook.UpdateLink Name:=aLinks(i), Type:=xlExcelLinks End If Next i End If Application.ScreenUpdating = True End Sub When I choose to debug the row that's hightlighted is " ActiveWorkbook.UpdateLink Name:=aLinks(i), Type:=xlExcelLinks" HELP!!! Thanks! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Run time Error '1004: Method 'Cells' of object'_Global' failed | Excel Programming | |||
Run-time error '1004'; Method 'Export' of object'_Chart' failed | Excel Programming | |||
UpdateLink giving error 1004 | Excel Programming | |||
ASP & EXCEL2003 - RUN-TIME ERROR 1004 in Export method | Excel Programming | |||
Run Time error '1004' when running Calculation method | Excel Programming |