By using listi.net you agree to our cookie policy, We and our partners operate globally and use cookies, for multiple purposes

listi.net

VBA on 2 or more Excel files opened at the same time

Thisworkbook
sWB = activeworkbook.name

Set wb = open ....

FindWBPartial

Workbooks("name_of_workbook").Activate

ThisWookbook.Sheets("sheet_name").Range("range_value")