Open And Activate Workbook Before Runing Macro

[snb]

If each workbook contains an 'auto' macro this will suffice (since an 'auto' macro runs automatically when opening the file...)

Sub M_snb()
    with getobject("C:\My Documents\BR1 parts sales.xlsm")
        .close true
    end with
    with Getobject("C:\My Documents\Br1 service sales.xlsm")
       .close true
    end with
End Sub

PS. Avoid 'Select' and 'Activate' in VBA.