Conflict with Workbooks

[kartune85]

I've got a slight problem with that I've used "ThisWorkbook" but from my code I've created a second workbook which is automatically named "Book1, Book2, Book3..." and I've got code in "ThisWorkbook" that moves a sheet from itself to the newly created workbook.

There's a conflict when someone tries to start a new Workbook while another one is still open and then "ThisWorkbook" tries to move a sheet from itself to "Workbooks(2)". Thus the confusion cause I think it gets confused as to which one is "Workbooks(2)" (Book1 or OldBook).

How can I refer to the newly created workbook without it getting confused with other workbooks that are already opened?

If there is some kind of testing procedure to stop the workbook from opening if there's others open would come in quite handy.

Kartune85

[Rich]

instead of creating the new workbook as workbook1, could you not adapt it to
create the workbook as "book1 (date and time) or application user name) or
sommert like that , this would help solve the conflict as its unlikly 2 ppl
will save at exactly the same time

"kartune85" wrote:

>
> I've got a slight problem with that I've used "ThisWorkbook" but from my
> code I've created a second workbook which is automatically named "Book1,
> Book2, Book3..." and I've got code in "ThisWorkbook" that moves a sheet
> from itself to the newly created workbook.
>
> There's a conflict when someone tries to start a new Workbook while
> another one is still open and then "ThisWorkbook" tries to move a sheet
> from itself to "Workbooks(2)". Thus the confusion cause I think it gets
> confused as to which one is "Workbooks(2)" (Book1 or OldBook).
>
> How can I refer to the newly created workbook without it getting
> confused with other workbooks that are already opened?
>
> If there is some kind of testing procedure to stop the workbook from
> opening if there's others open would come in quite handy.
>
> Kartune85
>
>
> --
> kartune85
> ------------------------------------------------------------------------
> kartune85's Profile: http://www.excelforum.com/member.php...o&userid=35586
> View this thread: http://www.excelforum.com/showthread...hreadid=554412
>
>