Updating links with VBA

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Update Password Protected Links 1
Problems with incorrect linked values 5
updating links alert 2
Update Links and Essbase Retrievals 6
Excel Spreadsheet display with autorefresh 1
XL03: Avoid "workbook contains links" msg when opening 5
Links cannot be updated 1
vba code does not run 3

Back
Top