split mutiple excel sheets to separate workbook/file

[hfibrahim]

Hi Friends,

i am looking to split my 15 tabs workbook file into separate files in each, can anyone help me on this. 

appreciated your help. 

[binuacs · Accepted solution]

@hfibrahim This can be done with the help of a batch macro, attaching a sample workflow for your reference

[hfibrahim]

thank you so much @binuacs for your quick response. i have one more clarity here, the way i am spliting the files the formats of actual files getting change, is there any way we can directly convert to pdf so that the file formats exits.

[binuacs · Accepted solution]

@hfibrahim If you want to write into a formatted file then you should go with the blob tools

https://community.alteryx.com/t5/Engine-Works/The-Blob-Reporting-That-Isn-t-From-a-Horror-Film/ba-p/...

[hfibrahim]

awesome, can we connect offline, ( syedibrahimhuffaz@gmail.com)

[binuacs]

@hfibrahim sure