Workbook.Open

[HunterN]

Hi!

I have in a macro the command
Workbook.Open filename:="...."

Can anyone tell me if there is a way to make it so it won't ask me to update the workbook when it opens? I want it to automatically select the option - No.

Thanks

 

[EdE]

Hi Hunter --

Workbook.open filename:="....", updatelinks:=0

0=no updates
1=update external but not remote references
2=update remote but not external references
3=updates both

Hope this helps!

 

[HunterN]

Thanks!

That is what I needed.