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

Once the code starts to execute it should not matter if the screensave
starts...

Pl. share the complete code...

Add Application.ScreenUpdating = False to avoid screen updating during the
execution...

"kevcar40" wrote:

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

the workbook containing the macro crashes if another excel workbook is
opened and being viewed this means that the active workbook is not the
workbook containing the call to update links

ActiveWorkbook.UpdateLink Name:=ActiveWorkbook.LinkSources

if the workbook containing the code is the active workbook no problem



On 24 Oct, 15:23, Sheeloo <="to" & CHAR(95) & "sheeloo" & CHAR(64) &
"hotmail.com" wrote:
Once the code starts to execute it should not matter if the screensave
starts...

Pl. share the complete code...

Add Application.ScreenUpdating = False to avoid screen updating during the
execution...



"kevcar40" wrote:
Hi
i have a workbook cntain a large number oflinksto several workbooks
i am trying toupdatethelinksautomatically
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
theupdatelinkscrashes
is there a way of getting thelinkstoupdatein the background ?
or
for the focus to the workbook so thelinkswillupdate
*i am using
* *ActiveWorkbook.UpdateLink Name:=ActiveWorkbook.LinkSources
if i change active to this workbook will it work?

thanks

kevin- Hide quoted text -

- Show quoted text -