Update Links

[Kevin]

Hi

I want to open a file but automatically say no to "update
links"

The below does not work in that it opens the file but
still asks if i want to update links

Workbooks.Open PLpath, UpdateLinks:=False

Any ideas
Thanks

 

[Tom Ogilvy]

Workbooks.Open PLpath, UpdateLinks:=0

Says not to update links. It should not ask after that.

There are no other argument alternatives to accomplish this (in xl2000 and
earlier) and it seems to work for everyone else. In excel 2002 and later
there is a setting you can make in the workbook that you would later open in
code. It is in Edit=>Links.