Hi,
I am looking to have an excel file with multiple sheets to be split into separate files for each sheet. If someone could provide a test workflow that I could adjust would be awesome.
Thanks,
Jon
Solved! Go to Solution.
You are the BEST!!!! Thank you so much for going above and beyond to help me. Have a great day!
Morning @Sebastiaandb,
I have another question if you do not mind assisting with. I was able to use your workflow to split an excel file into multiple files via its sheets. Now I need to find a way to set a password on each of those outputted files (password protected excel files).
Would you be able to assist me with this? I believe I may need to put a batch file in the macro which looks at a table to assign each workbook a password. (Each file needs to have a different password depending on sheet/file name).
Any guidance or assistance would be greatly appreciated !