Combine different Excel (xlsx) files into one file with different sheets Through SAS CMD/VB script

[SASuserlot]

I am looking to combine all the excel files in folder starts with a specific into one file ( use each individual excel file as sheet in combine file) after combination delete individual files.  I am looking to do it instead of importing them back into SAS datasets and doing proc report. Is there a way I can do it through  using  xCMD or vbscript code running through the SAS. Thank you.

[Reeza]

If they're all in one folder here's a script. https://www.codeproject.com/Tips/5264786/Merge-Many-Excel-Files-into-one-VBS
Last one on the page. I'd modify it to not use prompts and to have SAS pass the folder name.
Note that it combines all in a folder.

[SASuserlot]

thank you @Reeza . I will work on this. Will let you know if I encounter issues or need any updates.

[SASuserlot]

Hi @Reeza , I trying to use it, But I am struggling how to use the VBA code in SAS. Can you please provide some startup code to start on it.