I don't think I did: In your last post you said: "Is it because adding
a workbook  doesn't make it active?" I replied "It does." meaning that
i does make the new workbook the active one.

So your statement below "OK. Adding a workbook doesn't make it
active." is at odds with this.

This should answer all your questions below.