Using Macro to import excel files into active workbook

[ruby288]

Hello all,

Would greatly appreciate if anyone could show the code to import excel files into an active workbook with UI.

Let's say there are multiple excel files (.xlsx) in the folder "C:\Import Files".

These files have the following file names:
"FileA_Main.xlsx"
"FileA_Sub.xlsx"
"FileB_Main.xlsx"
"FileB_Sub.xlsx"

The active workbook (let's call it Master.xlsx) will have a UI in each sheet to import different files from that folder:
Sheet1 in the Master.xlsx file will import cell A1 to Z20 found in "FileA_Main.xlsx"
Sheet2 in the Master.xlsx file will import cell A1 to Z20 found in "FileB_Main.xlsx"

Is it possible?
Thanks in advance!

 

[patel45]

Merge data from all workbooks in a folder (1)

 

[ruby288]

Thanks. Do you mean merging all the files in that folder into one workbook?

 

[ruby288]

anyone can help?

Thanks