Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Update links (repost)
Hi
i have a workbook cntain a large number of links to several workbooks i am trying to update the links automatically i am trying to do this using a date serial value problem i have is if i loss focus on the workbook ie another workbook or screen saver the update links crashes is there a way of getting the links to update in the background ? or for the focus to the workbook so the links will update i am using ActiveWorkbook.UpdateLink Name:=ActiveWorkbook.LinkSources if i change active to this workbook will it work? thanks kevin |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Repost: Update querytable connections and refresh data | Excel Discussion (Misc queries) | |||
Repost: Disabling Update Links dialog box | Excel Discussion (Misc queries) | |||
Update links box gives Continue or Edit Links dialog | Excel Discussion (Misc queries) | |||
keep value from last update and don't ask to update links | Excel Discussion (Misc queries) | |||
can't update links...can't find links | Excel Discussion (Misc queries) |