Switch to open workbook with dynamic date in file name

[emoandy05]

Hello,

Hopefully this is one-liner.

I open a workbook using the following code:

Workbooks.Open Filename:="Z:\hq4p1v1\INVTRADE\El General\Early Return\" & Format(Now(), "m.d.yyyy") & " - PSRCashManagement.xls

"

Then I copy from it and paste into another workbook with a static name.

I need to switch back into the dyncamically named workbook again to copy/paste again.

How do I do this?
Then how to I close it?

Thank you!

 

[BobUmlas]

Set MyDynamicWB = Workbooks.Open (Filename:="Z:\hq4p1v1\INVTRADE\El General\Early Return\" & Format(Now(), "m.d.yyyy") & " - PSRCashManagement.xls)
Then to switch back to it:
MyDynamicWB.Activate
and
MyDynamicWB.Close

 

[emoandy05]

Set MyDynamicWB = Workbooks.Open (Filename:="Z:\hq4p1v1\INVTRADE\El General\Early Return\" & Format(Now(), "m.d.yyyy") & " - PSRCashManagement.xls)
Then to switch back to it:
MyDynamicWB.Activate
and
MyDynamicWB.Close

What if I have multiple dynamic workbooks?

 

[Fishboy]

What if I have multiple dynamic workbooks?

Set MyDynamicWB2 = another file path etc
Set MyDynamicWB3 = yet another file path etc
And so on...

You can flick between then as outlined by Bob by calling the relevant name and activating it.

 

[emoandy05]

thank you both!

 

[Fishboy]

Happy to help