Suppress 'This workbook contains links...'

[GSIV]

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?

[cssriraman]

Go to Tools -> Options -> Edit Tab and uncheck the option "Ask to update automatic links".

This might help you.
_______________________
CS

[BillBoeBaggins]

If your doing it in code it is also in the parameter list.

Excel.Application.Workbooks.Open "filepath",True

[GSIV]

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)