How to get around request to update when opening a form with vba

Is there a way, when opening another workbook with vba, when it asks if you want to update links to tell it no?
Sandra SmithRetiredAsked:
Who is Participating?
 
Saqib Husain, SyedEngineerCommented:
Try removing the parentheses

Application.Workbooks.Open strFileExportPathSumm & "TEST_ClientActiveMasterTemplate.xls", 2
0
 
Saqib Husain, SyedEngineerCommented:
Activeworkbook.open(filename,2)
0
 
Sandra SmithRetiredAuthor Commented:
I tried adding the parameter 2 to my open statement, but it turns red.

Application.Workbooks.Open (strFileExportPathSumm & "TEST_ClientActiveMasterTemplate.xls", 2)
0
 
Sandra SmithRetiredAuthor Commented:
I would never have thought of that!  Thank you.

Sandra
0
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.