I have an application consisting of two open workbooks. The first workbook
opens, then opens the second workbook. The second workbook contains very
little VBA code, just the following:

Private Sub Workbook_Open()

ThisWorkbook.RefreshAll

End Sub

When the End Sub is reached I get the error message Run-time error 9 -
Subscript out of range.

The purpose of the second workbook is to import a table from a mainframe,
which is then used by the first workbook using Vlookup. I would like to
have the application automatically reactivate the first workbook once the
second workbook has finished it's import and refreshed.

Any ideas are welcome.

Bill