Can't close an inactive Workbook - result in error 9

I have one WB open (ThisWorkbook) and the code bellows opens a 2nd one (cg.xlsm).
It copies cells A1:A1000 and pastes them into ThisWorkbook starting at L1500 on sheet Target Sheet.
This all works except for line above Sub , closing the captain_WB. How do I fix this?

Additionally, if I want to open the WB I use "Workbooks.Open captain_WB" but I tried to close the WB using "Workbooks.Close captain_WB" as it would seem to mirror the open WB line but that didn't work either. Help is appreciated.

Please Login or Register  to view this content.

captain_WB includes the path and filename, when you use Workbooks you ony need the filename.