Activate the temporary "Book1"

[bibux]

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

Workbooks.("Book1").Sheets("Stats").Activate

- to no avail.

 

[GTO]

I think I saw "export to Excel" in there, so that answers the first bit.

If yes - can you assure that you will start out with only one instance of Excel, and that the only other instance of Excel will be when the other app creates it,

AND,

that the other instance will only have the one workbook? That is, I am wondering if we could (via code) look for the one other instance and workbooks(1) therein.

I could not glean these from your video.

 

[bibux]

To echo Norie's question a bit, are you "manually" creating the (presumably a report of some type) workbooks whilst using (i.e. - I clicked a button or something) the other application?

If yes - can you assure that you will start out with only one instance of Excel, and that the only other instance of Excel will be when the other app creates it, AND, that the other instance will only have the one workbook? That is, I am wondering if we could (via code) look for the one other instance and workbooks(1) therein.

Mark

The way I'm seeing it is: the main workbook will be open and waiting for "Book1" to be generated. Once "Book1" is ready, with the code from "Main", go to "Book1" and copy/paste the data.