Open Linked Excel File Without Link Message

I am using Access to open an Excel workbook that has links in it. Is there something I can add to the "objExcel.Workbooks.Open modGlobal.g_strTemplate" code so that the Excel does not launch the "This workbook contains links" message?

Buck_BeasomDatabase DesignerAsked:
Who is Participating?
Dale FyeCommented:
Try this

objExcel.Workbooks.Open Filename:="C:\Workbook.xls", UpdateLinks:=False
Buck_BeasomDatabase DesignerAuthor Commented:
Outstanding! Thanks.
Dale FyeCommented:
Glad to help.  BTW, if you need to update the links, set it to true.
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.