Is there any VBA code to let Excel select a user-defined option from a pop-up window

I need the output from spreadsheet C, but C requires input values returned by running spreadsheets A & B in order. I use VBA code (Workbooks.Open) to open A & B, but they both contains links to other data sources. As soon as the workbooks are opened, there will be a pop-up window asking the user to choose between "Update data" and "Don't update", and the operation of my VBA code breaks down here. Is there any VBA code available to make Excel select the "Don't update" option automatically?

(Since A & B contain some cell of same functions, I can't put them in one spreadsheet. I tried to rename functions in one of the spreadsheets, but then it failed to work)

Hi,

If your opening the workbook via code, try:

Please Login or Register  to view this content.

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

Hope this helps,
mccreaso

Thanks a lot for your code. That was very helpful. I tried to open the spreadsheets A & B then run them by using the code
Workbooks(“C:\Book A.xls”).Activate

somehow it doesn't work for me.