If you use 'Open Workbook', it is opening the workbook. It's just invisible. The way I pretty much always do it is in this order:
Create Instance
Open Workbook
Get Collection
Close Instance
You do not need to specifically close the workbook since Close Instance will take care of that for you.
Dave Morris, 3Ci at Southern Company