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
Atlanta, GA