Question: how to copy data from one file to another in excel using vba?
Answer: Open an excel workbook., Enter some data in Sheet1 at A1:B10., Press Alt+F11 to open VBA Editor., Insert a Module for Insert Menu., Copy the above code and Paste in the code window., Save the file as macro enabled workbook., Press F5 to run it.