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: