Hi i am working on a Project where i have close to 40 different input files, saved in a single folder, the file names and sheets names are different. Is there a solution / tool to read all the files and the tabs within them?
Hi @Janardhanan_M have a look at the solution from this post it uses two Batch Macros. One to get the sheet names from your excel files then another to read all the data dynamically
@Janardhanan_M Have you tried to do anything to solve your problem before posting your question here?
Simple googling would bring you to the post that @JosephSerpis shared here.