Working on two or more Excel files using macro

Application.Workbooks("<Excel_Name1>").Worksheets(1).Range("A1").Value = "Hello"


http://www.excel-easy.com/vba/create-a-macro.html