Read All Excel Files From a Folder

Question

Hi all,

Can someone help me out with a Solution. I want to read all the Excel Files from a Folder at once. All the files have the Same Structure and has only one single Sheet named Report. I tried with a macro but the sheet name is not coming up. Please assist

flying008 · Accepted Answer

Hi, @DataPirate26

Dear , As @SPetrie said, If your all  xlsx file have same schema and only for one sheet name, you just use a wildcard to cover all xlsx file name in path by C:\abc\123\*.xlsx

binu_acs · Accepted Answer

@DataPirate26 One way of doing this with the batch macro