Splitting Excel File to multiple Outputs

[jsilavong]

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

[jsilavong]

@Sebastiaandb 

You are the BEST!!!! Thank you so much for going above and beyond to help me. Have a great day!

[Sebastiaandb]

@jsilavong 

No problem! Awesome reply, just made my day!

[jsilavong]

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 !