assign variable name to the workbook

Hi, all. please help woth this problem.
I want to open two file at the beginning of the code, like below, and after the two files are opened, i want to activate one of the file first, and i must write the exactly same name as the workbook name, then i can activate the window. Is there any way so that assign a variable to the workbook name, and any time, i call the variable, it will know which window should be activated.

Please Login or Register  to view this content.

in this example, the two file name are "PriceList" and "CombinedPriceList". If i change the file name to "PriceList01" and "CombinedPriceList01", then the macro will get error. so i want to overcome this problem.
Any help will be appreciated!

Like so:

Please Login or Register  to view this content.

Hello,

I'd tackle it this way:

- count how many workbooks are currently open
- open the first workbook with the macro
- get the name of that workbook with the workbooks index into a string variable
- open the second workbook with the macro
- get the name of that workbook with the workbooks index into a string variable
- open each workbook by its string variable

something like

Please Login or Register  to view this content.

JB, of course! Experience shows!

If that takes care of your need, please click EDIT in your original post, click GO ADVANCED and set the PREFIX box to SOLVED.

yjmmay, people will get to your post in their own time. They will decide if they want to answer. You can't make them. Please don't push. We're all volunteers here, investing our own free time.