Set unknown worksheet name in different workboojk as "wsSrc"

Having a "senior moment" in this.

Have data held in worksheet with unknown name in file X that needs to be pulled across to a worksheet in the Active workbook.

I set the "other" workbook as "wbSrc" and can open it automatically. I can get a MessageBox giving me the "worksheet name" that it opens at,

What I can't manage is to define that worksheet as "wsSrc"?

Please Login or Register  to view this content.

Can't see why it goes wrong?

All solutions, suggestions or alternatives welcome as ever


Ochimus