Excel Vba Import Sheet From Another Workbook Without Opening - Private sub workbook_open() ' when the file opens. Is there a way to copy data from an open workbook to a workbook that is not open without opening it? Hi, looking to pull the. Web option explicit sub importdata_click() dim objexcel2 as object, arr as variant set objexcel2 =.
Hi, looking to pull the. Is there a way to copy data from an open workbook to a workbook that is not open without opening it? Private sub workbook_open() ' when the file opens. Web option explicit sub importdata_click() dim objexcel2 as object, arr as variant set objexcel2 =.