Excel: Activate the temporary "Book1"

I am trying to activate a "generated" workbook that is unsaved and has no extension, just the name "Book1". If I save it as "Book1.xlsx" and then repoen it, I can refer to it. Like this.

Set sh = Workbooks("Book1.xlsx").Sheets("Stats")
Set rng = sh.UsedRange
The question is, can I refer to it while it is unsaved and named simply "Book1"? I have tried
- to no avail.

This question generated 22 answers. To proceed to the answers, click here.

This thread is current as of May 04, 2014.

For more resources for Microsoft Excel