| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
UpdateLink giving error 1004
I've tried the below code in ThisWorkbook in both Workbook_Activate() and
Workbook_Open() ThisWorkbook.UpdateLink Name:=ThisWorkbook.LinkSources or ActiveWorkbook.UpdateLink Name:=ActiveWorkbook.LinkSources Both throw a run-time error '1004'. Message is 'UpdateLink' of object '_Workbook' failed. The other workbook is not open yet. Is this the cause of the problem? If so what can I do about it? Do I need to open them simultaneously? If so, how can I do that? -- DRK |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Giving me a error ( =REF! ) | Excel Worksheet Functions | |||
| Function giving error | Excel Discussion (Misc queries) | |||
| Function giving Error | Excel Worksheet Functions | |||
| run-time error '1004': Application-defined or object-deifined error | Excel Programming | |||
| Protect Sheet but enable cell ranges giving Error 1004 Unable to set | Excel Programming | |||
Threaded Mode
