Updating dependent workbook query in Events (THIS TOPIC IS N

[Jak]

When I re-open a dependent workbook, Excel recognizes the fact that there are dependencies and asks if I want to use the old data or get the new information from the workbooks via a pop up form.

Is there a method of updating the dependencies via VB code in the On_Open Event? Thereby bypassing Excel pop ups!
This message was edited by Jak on 2003-01-18 04:39