Saving file tabs as seperate individual files

[Colin]

In past versions of Excel you could save file tabs as
seperate Excel files...how is this done in Excel 2000?

Once they are seperate is there any way to bring a series
of individual files back together as one file with many
tabs?

 

[Ron de Bruin]

You can use this to save each tab as a file

Sub test()
Application.ScreenUpdating = False
For a = 1 To Worksheets.Count
Sheets(a).Copy
ActiveWorkbook.SaveAs Sheets(1).Name
ActiveWorkbook.Close False
Next a
Application.ScreenUpdating = True
End Sub

Once they are seperate is there any way to bring a series
of individual files back together as one file with many
tabs?

Try this

http://www.rondebruin.nl/copy3.htm