Update links

[Guest]

HI

Thanks for the response on previous questions, it's really helping me along

Now for the next one

One of the workbooks I ref has a link inside it. It looks like a link my
supplier uses to populate it before posing it to me, anyway. When I call the
sheet it asks to update links or not. How do I automate this to No. I used
the following line

Application.AskToUpdateLinks = False

But that must reply with the default answer, which in this case is update
links, so another message comes up saying it can't find the linkd file.

Thanks
Craig

 

[acampbell012]

Would Application.DisplayAlerts = False when opening your workbook?

 

[Guest]

If you're opening the workbook in code then the argument after the filename
is UpdateLinks.

Workbook.Open(FileName, UpdateLinks, ReadOnly, Format, Password,
WriteResPassword, IgnoreReadOnlyRecommended, Origin, Delimiter, Editable,
Notify, Converter, AddToMRU)