Posts by CroatiGio

    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



    Code
    Workbooks("Justin Dashboard 2019").Active



    just without a variable.
    This is blocking my work


    Any help would be of big help!
    Thank you in advance


    Giorgio