split Excel file into multiple files

[gpsurf]

I was wondering if anyone can help me. I have a workbook that is created every month from FRX (reporting tool) and creates one excel file with 65 separate tabs. Each tab has a separate department’s budget. I need to break this file apart and save each tab as a separate file. It is very time consuming, so is there a way to automate this process? Just splitting the file apart would be a big time saver I can then just save the files in each of the budget folders. I have some VBA experience but not enough to write this code.<?xml:namespace prefix = o ns = "urn:schemas-microsoft-comfficeffice" /><o></o>
<o></o>
Thanks<o></o>
GP<o></o>

 

[VoG]

Hello and welcome to MrExcel.

Try

Sub try()
Dim ws As Worksheet
For Each ws In ThisWorkbook.Worksheets
    ws.Copy
    With ActiveWorkbook
        .Save
        .Close False
     End With
Next ws
End Sub

 

[texasalynn]

take a look at this:
http://www.mrexcel.com/forum/showthread.php?t=376112
http://www.mrexcel.com/forum/showthread.php?t=371562

BTW - I use FRx also, do you have GP or some other accounting package

 

[gpsurf]

Thanks for the quick response! I will try your solutions and let you know how they work out.

GP

 

[gpsurf]

BTW - I use FRx also, do you have GP or some other accounting package

Yes I am using GP and FRX. FRX is great for financials but I need the budget files in excel. We are trying to rework the way we distribute reports.