There is probably a real simple code but I looked around and could not find it. At any given point I will have two workbooks open, one will remain and the other will be closed and another one open so the workbook name will change. How do I get VBA to select the inactive workbook since the name will change? I hope that makes sense.
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
Select Misc Workbook with VBA
- Thread starter tcnt9176
- Start date
-
- Tags
- toggling workbooks
Norie
Well-known Member
- Joined
- Apr 28, 2004
- Messages
- 76,377
- Office Version
- 365
- Platform
- Windows
I'm sorry it doesn't quite make sense, to me anyway.
What are you actually doing with these workbook(s) and where is the code located?
You can refer to whatever workbook the code is in using ThisWorkbook and you can create a reference to a workbook when you open, like this perhaps.
What are you actually doing with these workbook(s) and where is the code located?
You can refer to whatever workbook the code is in using ThisWorkbook and you can create a reference to a workbook when you open, like this perhaps.
Code:
Set wbThis = ThisWorkbook
Set wbOpen = Workbooks.Open("C:\WorkbookX.xls")
' work with wbOpen
' close worked book that was opened
wbOpen.Close
Upvote
0
Similar threads
- Solved
- Question
- Question
