Excel Vba Get Data From Closed Workbook

Excel Vba Get Data From Closed Workbook
Import Data From Closed Book Based On The Value In The Cell (Without Using ADO)

         The wanted values are being fetched from other closed books according to Product No. in the in main file's column B . The fetched values are listed in sequential rows.

          There are 3 books in the same folder -according to need may be more than files - : main_file.xls , 13,xls , 14.xls . In our example, product numbers are starting 13 or 14 . For this reason ,the files are opens according to product no. (13.xls or 14.xls) and values are entered into main_file.xls.