Stop Update / Don't Update requestor message

[Glio]

I have some VB code which sequentially opens over 200 workbooks to extract data from each and populate another workbook. These workbooks do have links to other workbooks in them.
For some reason when some of these workbooks are opened I get a requestor window asking whether I want to Update or Don't Update the data. I always want to Update the workbook and believe this can be done in VB by hiding the requestor?
Can anyone help me please.

Regards

Geoff

[Glio]

Further to my last. I have tried putting the following code in the module that selects the data from each workbook - to no avail.

Please Login or Register  to view this content.

Any ideas.

Geoff

[Cheeky Charlie]

Help for "Open Method" (just 10 lines in to the section!):

UpdateLinks Optional Variant. Specifies the way links in the file are updated. If this argument is omitted, the user is prompted to specify how links will be updated. Otherwise, this argument is one of the values listed in the following table.

Value Meaning
0 Doesn't update any references
1 Updates external references but not remote references
2 Updates remote references but not external references
3 Updates both remote and external references

So:

Please Login or Register  to view this content.

becomes

Please Login or Register  to view this content.

You can do better than this...

[Glio]

Cheeky Charlie - Thanks for your response which doesn't appear to work on the following line

Please Login or Register  to view this content.

I tried adding

Please Login or Register  to view this content.

at the end but get a compile error.

Regards

Geoff

[royUK]

Try this

Please Login or Register  to view this content.

Your code has \ instead of /,

Please Login or Register  to view this content.

[Glio]

RoyUK, thanks for your comments.

Changing the \ to a / didn't make any difference to the way the code ran, but I still cannot make the code update remote and external references automatically by adding 3 to the end of the line. As soon as I do add the 3, the code does not compile.

This is the start of the code I am trying to update to stop the appearance of the "Update - Don't Update" windows.

Please Login or Register  to view this content.

[royUK]

Did you use the line

Please Login or Register  to view this content.

[Glio]

I have sorted the problem out, by changing the line

Please Login or Register  to view this content.

to

Please Login or Register  to view this content.

Thanks again to Cheeky Charlie for pointing me in the right direction.

Regards

Geoff