I am trying to seta variable in one workbook, to then pass it to another workbook.

In workbook A, I have this code:

    Dim Target, Test_Emp, Test_Row
    Dim TestModel, TargetBook
    
    
    Sheets("testing_menu").Select
    Target = Range("test_target")
    Test_Emp = Range("A15")
    TestModel = ActiveWorkbook.Name
    
'Other code running here
'.....

    Application.Run ("'" & Target & "'!Queries_3")

The last line runs a macro called Queries_3 in workbook B.

I am trying to pass a global variable, from workbook A to workbook B, but have exhausted my googling.

Any help would be really really great!.

Thanks