Open/manipulate a workbook using BeforeClose event

[The_Kurgan]

I'm attempting to use the BeforeClose event to open another workbook, gather data, and then place it into the original workbook. However, once the workbook is open, the code fails to manipulate it. The ribbon and tabs don't seem to be visible and when the code tries to activate the new workbook or select a tab within it, I get a "Subscript out of range" error. Any workarounds or fixes?

The code is very basic:

Workbooks.Open Filename:="X:\Accounting\Warehouse.xlsx"
Windows("Warehouse.xlsx").Activate   '"Subscript out of range" error
Sheets("WH Forecast").Select

TIA

 

[MoshiM]

I'm attempting to use the BeforeClose event to open another workbook, gather data, and then place it into the original workbook. However, once the workbook is open, the code fails to manipulate it. The ribbon and tabs don't seem to be visible and when the code tries to activate the new workbook or select a tab within it, I get a "Subscript out of range" error. Any workarounds or fixes?

The code is very basic:

Workbooks.Open Filename:="X:\Accounting\Warehouse.xlsx"
Windows("Warehouse.xlsx").Activate   '"Subscript out of range" error
Sheets("WH Forecast").Select

TIA

dim WB as workbook
set WB=Workbooks.Open(Filename:="X:\Accounting\Warehouse.xlsx")
WB.Sheets("WH Forecast").Select

 

[The_Kurgan]

Like a charm! Thank you!