Question: how to import data from one excel spreadsheet to another using vba?
Answer: Import Data from another Closed Workbook with VBA Just do the following steps: #1 open your excel workbook and then click on “Visual Basic” command under DEVELOPER Tab, or just press “ALT+F11” shortcut. #2 then the “Visual Basic Editor” window will appear. #3 click “Insert” ->”Module” to create a new module.