Need tabs moved using VBA

[frets2011]

1. I have one excel file with many tabs
2. I need to move each tab and make it its own workbook
3. I also need the new workbook file to be named using its tab name
4. Can all this be done using VBA?
5. I will need the code thanks

 

[hiker95]

frets2011,

Welcome to the MrExcel forum.


See:
Sheets to WB(1)
Specifications:
One workbook with many sheets
Need a separate workbook for each sheet so they can be sent to various departments without sending whole wb.
https://sites.google.com/a/madrocke...celassistant/parse-functions/each-sheet-to-wb

 

[AlphaFrog]

Hi and welcome.

http://www.mrexcel.com/archive/VBA/5788.html

 

[frets2011]

Thanks AlphaFrog, I used your method and it worked just fine.