Suppress 'This workbook contains links...'
I am using an Excel worksheet that contains DDE links as part of a vb.net automation project. However, when I call the worksheet, I get the message "This workbook contains links to other data sources." Once I select OK to update the links everything else proceeds fine. Is there anyway to suppress this dialog and automatically update the links?
Re: Suppress 'This workbook contains links...'
Go to Tools -> Options -> Edit Tab and uncheck the option "Ask to update automatic links".
This might help you.
_______________________
CS
Re: Suppress 'This workbook contains links...'
If your doing it in code it is also in the parameter list.
VB Code:
Excel.Application.Workbooks.Open "filepath",True
Re: Suppress 'This workbook contains links...'
Thanks for the replies. This is what I wound up using... it works great.
' updatelinks=3 to update or updatelinks=0 to not update
xlWB = xlApp.Workbooks.Open(xlFile, updatelinks:=3)