Workbook Name

[dave8]

I have a program that is using two workbooks. Actually, the first workbook opens the second workbook. Therefore, for example, Workbook1 and Workbook2. So, if in Workbook1, how to set the name of the workbook to Workbook2, and vice versa?

 

[Datsmart]

Take a look at this similar request from a number of years ago.
http://www.mrexcel.com/forum/showthread.php?t=376584

The sample code there should help you.

 

[repairman615]

Hello,

I may have misunderstood and could be way off...


Do you mean how to differentiate between the two in VBA?

If so, and if I remember correctly:

Windows("Workbook1").Activate

Or

Workbooks("Workbook1").Sheets("Sheet1").Range("A1").Activate


Another way may be like:

msgbox Workbooks(1).Name
msgbox Workbooks(2).name

Does any of that help?

-Jeff

 

[dave8]

Yes, this works for me. Thank you.