Saving file tabs as seperate individual files

  • Thread starter Thread starter Colin
  • Start date Start date
C

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?
 
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?
Click to expand...

Try this

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