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.
The question is, can I refer to it while it is unsaved and named simply "Book1"? I have tried
Set sh = Workbooks("Book1.xlsx").Sheets("Stats") Set rng = sh.UsedRange
- to no avail.
This question generated 22 answers. To proceed to the answers, click here.
This thread is current as of May 04, 2014.