excel spread sheet with multiple tab 1-100 need to make each tab its own file

[spudn56]

excel spread sheet with multiple tabs 1-100 need to make each tab (work sheets) its own file.
I had a macro to do that but no clue how to make them into own files. I have no experience doing this.
I made a fictitious spread sheet to test that is a pic with 6 workbook to split.

[LeoTaxi]

Please Login or Register  to view this content.

this create files in same folder, to choose folder change red part

kind regards
Leo

[spudn56]

How do I find exact path. I saved it on my desk top in a folder called split work book

[LeoTaxi]

if you want the files in same folder you can use Thisworkbook.Path

[davesexcel]

Save the attached workbook into a separate folder, then run the code. It will create and save the workbooks into that folder.

Please Login or Register  to view this content.

may7-1.jpg

[spudn56]

Thank you works great!!!