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

948 Steps to 6 Figures by Learning Excel-VBA and Other Skills

Step 84 - 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")