See attached code.
This code was generated by "Recording" key strokes. (I think)
The sequence is as follows;
1. Open workbook "BOOK_A".
2. Run the macro below which opens workbook "BOOK_B" (and copies data from "BOOK_B")
3. The data from "BOOK_B" is then pasted into "BOOK_A".
Question: I do not want to hardcode the "BOOK_A" workbook in the VBA. Since I begin in BOOK_A how can I simply re-activate this book without specifying the hard-coded name.
This is the problem VBA line (I merely want to re-activate the sheet that I started in).
' TBImportIRE Macro
Sheets("IRE TB - Current").Select