• Hot Topics

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. Code: 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 Code: Workbooks.("Book1").Sheets("Stats").Activate - to no avail.

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

This thread is current as of May 4, 2014.

For more resources for Microsoft Excel:

This article includes the following tags:

  • Excel
  • Microsoft Excel