Requesting ideas/help to read multiple excel files from a folder in server efficiently?

[novinosrin]

"I don't think this deals with multiple sheets in each file, is that something you need to deal with?"

Thankfully No 🙂  Just one sheet in an xlsx file. The number of xlsx file in a folder is 132 dowlnoaded from Bloomberg

[Reeza]

Do you have access to Bloomberg API? If so, you may be able to transition to using the API at some point instead if that's an option. Worth running by your supervisor at some point if its an option or possibility. Allows you streamline a process so you're avoiding the download step entirely.

[Reeza]

Also, this is a VBS script but you may not have x command, if that happens, just go to the folder and double click the vbs file created and it will run.

[novinosrin]

Thank you @Reeza  for the timely help. That was something special 🙂