excel - Macro Code to import data -

excel - Macro Code to import data -

how import 1 excel file using vba?

from req list test.xlsx columns b k o p l m n u v req list test day count summary.xlsx columns b c d e f g k l

both files on same path:

c:\users\msiddique\desktop

the range rows should unlimited, master file updated daily , more rows added.

windows("van baan naar ax nederland.xlsx").activate cells.select selection.copy windows("van baan naar ax nederland met macro's.xlsm").activate cells.select activesheet.paste

if set in same window pretty easy, have open both files.

excel excel-vba