Update links
 

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

Update links
 

Would Application.DisplayAlerts = False when opening your workbook?


Craig McK wrote:
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

Update links
 

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)

"Craig McK" wrote:

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