I think the title says it all for this question but to elaborate a bit further:
I have a .xlsx file which contains a few dozen sheets. I want to output all of those sheets as separate .xlsx files. Automated naming of them isn't necessary. Does excel have a function to export sheets to a separate file?
Best Answer
It is not a built-in feature.
However, if you run this code, it should do the job.
To run the code, do the following:
SaveSheets
or see How do I add VBA in MS Office?