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"?
Can't see why it goes wrong?Please Login or Register to view this content.
All solutions, suggestions or alternatives welcome as ever
Ochimus
Bookmarks