I am unable to work with Workbooks which name is based on a Variable
Code
Sub test2()
Dim MyFile As String
MyFile = "Justin Dashboard 2019"
Workbooks(MyFile).Active
End Sub
This gives me the error "Object doesn't support this property or method"
Of course I need a dynamic variable which will be changed based on other variables etc... in the future.
but for now, I am not even able to go further unless I put
just without a variable.
This is blocking my work
Any help would be of big help!
Thank you in advance
Giorgio