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.
Polls
We’re dying to get your help in determining what the new profile picture frame should be this Halloween. Cast your vote and help us haunt the Community with the best spooky character.
