Passing a variable between modules in VBA

Works for me, passing the variables to module 2 - tested with the following:

Sub importOrderSubs()
    Debug.Print tradingSpreadsheet
    Debug.Print referenceClientWorkbook
    Debug.Print userLocation
    Exit Sub

So, if you still have a problem, it is not that the variable values aren't reaching module 2.