Reference Worksheets Using Variables In A Table

I am very green at this so be gentle with me.

What I would like to do is use table data in a master document to move between documents in VBA. I have other grand plans but this is the first step. And I am stuck already

The cell U3 in my master doc references text "D_1" and I want this to change the window / workbook to "Week 1.cvs".

If I change the main line to Windows(D_2).Active this functions perfect.

I will of course populate this significantly more once I get this to function.

Any advice greatly appreciated.

Cheers

Please Login or Register  to view this content.

Expected this to change between open windows / workbooks.

Instead came up with a RUNTIME error

Administrative Note:

Welcome to the forum.

We would very much like to help you with your query, however it has been brought to our attention that the same query has been posted on one or more other forums and you have not told us about this. You are required to do so. Cross-posts are allowed but you must provide a link to your posts on other sites.
For new members: you will not be able to post a full URL, so remove the https://www. section and add one or two breaks to the rest of the address. A Moderator or Admin will then fix the link for you.

Please see Forum Rule #7 about cross-posting and adjust accordingly. Read this to understand why we (and other sites like us) consider this to be important: https://excelguru.ca/a-message-to-forum-cross-posters/

(Note: this requirement is not optional. As you are new here, I shall do it for you this time: https://www.mrexcel.com/board/thread...table.1273631/)

Additional crossposts:
https://chandoo.org/forum/threads/re...a-table.58640/
https://stackoverflow.com/questions/...les-in-a-table

I have no idea what you're trying to achieve but maybe something like this helps.
According the value in Range U3 one book or another gets activated.
There is no error checking thus when the workbook isn't open you'll receive an error message.

Please Login or Register  to view this content.

Welcome to the Forum Deakzy67!

Your profile says

Originally Posted by Deakzy67

MS-Off Ver: Business

but that is not an Excel version. Please update your profile to show the commercial release name (e.g., Excel 2016, Excel 2024, Microsoft 365). It is also helpful to include the update version, which will look like 2502 to indicate year and month the update was released. Knowing your Excel version will allow us to tailor a solution that we know will work for you. Thanks,