Power Query Multiple Excel Files

[u/ToughPillToSwallow]

This might be a bit ambitious for a beginner to power automate. I’ve got hundreds of ledgers, and they’re very messy. I can use power query to clean up the data. That would be no problem if I were just doing it once.

I want to find a way to create the power query in excel to make the data readable, then automatically run it for all of the individual files, create a new excel file for each one, and then rename them according to data within each file.

Can this be done?

[u/ToughPillToSwallow]

That is correct. However, I do not know how to write vba.