Conflict with Workbooks

  • Thread starter Thread starter kartune85
  • Start date Start date
K

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
 
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Change workbook name to a generic name 4
How to Refer to Another Excel Workbook 1
Reference a workbook level named variable. 8
Reset New Workbooks 2
Calling open workbook from another workbook 8
Closing Workbook then Activating Other Wb with Userform showing? 1
how do import data from two sheets into one 2
Opening a new workbook via a macro 2

Back
Top