[Intern Help] Auto close a linked workbook on exit

[djmelanson]

Hi guys, sorry to repost but my last title was a bit off target. I have two workbooks named Book1 and Hydro Line Stops. I created a macro that opens the Hydro Line Stops file automatically upon opening Book1. I have copied what I have so far below:

Private Sub Workbook_Open()
Workbooks.Open Filename:="\\bdl0fs05\Departments\Hydro Mechanical\Production Management\OE Open Order Status\Hydro Line Stops.lnk"
ThisWorkbook.Activate

End Sub

This works perfectly fine but I would like to also close the Hydro Line Stops file automatically when I close the Book1 workbook. I have tried:

Workbook("Hydro Line Stops.xls").close False

but I must be doing something wrong here because it comes up with a "Run-time error '9. Subscript out of range" error. Any help would be appreciated. Thanks.

 

[Joe4]

Duplicate: http://www.mrexcel.com/forum/excel-questions/860193-auto-close-workbook-closing-workbook-macro.html

Please do not post the same question multiple times. All clarifications, follow-ups, and bumps should be posted back to the original thread. Per forum rules, posts of a duplicate nature will be locked or deleted (rule #9 here: Forum Rules).