dialog boxes when executing VBA

[ItalianPlatinum]

Hello - I have code that will open a workbook then perform activities. But when doing so the user needs to click through the below two boxes. is there a way to have the code always "update" and "continue?"

 

[JoeMo]

Modify your code so the workbook open line includes the updatelinks argument:

Workbooks.Open Filename:="filepath & name between the quote marks", UpdateLinks:=False

 

[ItalianPlatinum]

Modify your code so the workbook open line includes the updatelinks argument:

Workbooks.Open Filename:="filepath & name between the quote marks", UpdateLinks:=False

ok so if i want to update links i just do true?

 

[JoeMo]

ok so if i want to update links i just do true?

Give it a try.

 

[ItalianPlatinum]

ADVERTISEMENT

Give it a try.

so that solved for the first box. how do I solve for this one?

 

[JoeMo]

Try adding these lines before and after the Workbooks.Open ....... line
Before:
Application.DisplayAlerts = False
After:
Application.DisplayAlerts = True

 

[ItalianPlatinum]

Try adding these lines before and after the Workbooks.Open ....... line
Before:
Application.DisplayAlerts = False
After:
Application.DisplayAlerts = True

works, thanks

 

[JoeMo]

works, thanks

You are welcome - thanks for the reply.