Activate workbook without exact name

[Street3]

Hi all,

So in my process I am opening 3 workbooks. At the beginning of the macro I want to save the previous "Information MM-DD-YY.xls" as a new workbook "Information MM-DD-YY.xls" using the current date. This is easy using the ActiveWorkbook.Name script but sometimes this isn't the active workbook.

Is there a way to activate this workbook? I'm having trouble because the dates change. Maybe tell it to search for a workbook using tab names???


Thanks,
Street3

[davegugg]

What are the names of the other two workbooks you have open?
What are the names of the tabs in the workbook you want to save with the current date?

[Street3]

Other two workbooks are "Data.xls" and "Chart.xls"
There are 9 tabs in the workbook I want to save. The first 3 are "Matrix In," "Matrix Out," and "Sheet1."

[davegugg]

Try this:

Please Login or Register  to view this content.

It checks the workbook is NOT one of the other two you have open. Should be faster and more accurate than dealing with worksheet names.

[Street3]

Thanks for the help Dave, but this script is reverting me back to the "Chart.xls" workbook. I might like to use the sheet reference because more than these 3 workbooks may be open at the time. I'll do a google search and see what I come up with.

[davegugg]

The reason for the problem is I should have layered the workbook names like this:

Please Login or Register  to view this content.

I misused the AND, sorry.

This one still stays with the workbook method, but it won't matter how many workbooks you have open, as long as there is only 1 with "Information" in the name.

Please Login or Register  to view this content.

Otherwise, if you really want to use the worksheets:

Please Login or Register  to view this content.

[Street3]

Thanks Dave works perfectly. Exactly what I needed!