Updating links with VBA
 

Hi Everybody.

I have a VBA program in Excel that opens multiple spreadsheets to extract
data to a seperate spreadsheet file. Some of the workbooks I open contain
links from spreadsheet to spreadsheet. What I would like to do is have the
workbooks open but not ask if I want to update the spreadsheet links. Is
there a way that I can open workbooks and cancel the update links msg through
code so I don't get the msgbox asking me if I want to update links? Clicking
"No" 30 times everytime the program is run is getting a little annoying!

I tried setting "DisplayAlerts=False" but that didn't work, is there any way
this can be done?

Thanks in Advance..

JT

Updating links with VBA
 

Nevermind, I found it..

"J. Toews" wrote:

Hi Everybody.

I have a VBA program in Excel that opens multiple spreadsheets to extract
data to a seperate spreadsheet file. Some of the workbooks I open contain
links from spreadsheet to spreadsheet. What I would like to do is have the
workbooks open but not ask if I want to update the spreadsheet links. Is
there a way that I can open workbooks and cancel the update links msg through
code so I don't get the msgbox asking me if I want to update links? Clicking
"No" 30 times everytime the program is run is getting a little annoying!

I tried setting "DisplayAlerts=False" but that didn't work, is there any way
this can be done?

Thanks in Advance..

JT