VBA question to activate workbook with variable name

[icy8s111]

I'm trying to create a vba for a workbook to switch to that workbook but the name of that workbook could change.

For example. I'm using a workbook and save that workbook with today's date added to the name.

My current VBA currently copies a range of data, opens another spreadsheet, pastes that data, Returns back to the original workbook.

The issue is that because the original name was changed the switch back to the original workbook will no longer work.

I've found a few solutions but I'm not sure exactly which to use. Any suggestions would be most helpful.


Thanks!

 

[HaHoBe]

Hi,

if the code is located in the workbook you want to return to that will always be ThisWorkbook no matter what the name is. If we are talking about any other workbook you want to return to closing the opened workbook will bring you back to the workbook which was the last to hold the focus in Excel. And to make it safe you can set an object to the workbook you start copying like

Set wbReturn = ActiveWorkbook
'run the copy
wbReturn.Activate 'only for demonstation here

Holger

 

[icy8s111]

Thank you! I didnt realize ThisWorkbook.activate was an option. That was exactly what I needed!


Thanks!!

 

[HaHoBe]

Glad if we could help out here. And maybe have a look at VBA to close workbook with different name at the end.

Holger