B
Bill Murphy
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
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