Split tabs into different files

  • Thread starter Thread starter mkk
  • Start date Start date
M

mkk

Hi,

I have about multiple tabs in 1 worksheet. Is there any way of savin
each tab as an individual file other than copy pasting?

thanks,
M
 
Right click in the sheet tab and choose "Move or Copy".
Expand the "To Book" box, and choose "(new book)".

To *move* the sheet to the new book, click <OK>.
To *copy* the sheet to the new book, check the "create a copy" box and then
click <OK>.
--

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================

Hi,

I have about multiple tabs in 1 worksheet. Is there any way of saving
each tab as an individual file other than copy pasting?

thanks,
MK
 
One way:

Drag the tab to the desktop

another:

Choose Edit/Move or copy sheets and select (new book) from the To book
dropdown.
 
With this simple example you can do this

Sub test()
Dim a As Integer
Application.ScreenUpdating = False
For a = 1 To Worksheets.Count
Sheets(a).Copy
ActiveWorkbook.SaveAs "C:\" & Sheets(1).Name & ".xls"
ActiveWorkbook.Close False
Next a
Application.ScreenUpdating = True
End Sub
 
JE McGimpsey,

"Drag the tab to the desktop"

That's a new one to me and it doesn't work in XL2002 (WindowsXP).
The image changes and has a slash thru it when its over the desktop.
Am I missing something?

Regards,
Jim Cone
San Francisco, CA
 
You sure it's MacXL only?

It worked ok for me.

But I bet they didn't drag and drop to xl's desktop.

The desktop isn't the window's (or Mac's) desktop--it's that grey area that you
can see if you Window|arrange|cascade inside excel.)

You Mac guys got nothin' on us!!!

<vbg>
 
The desktop isn't the window's (or Mac's) desktop--it's that grey
area that you can see if you Window|arrange|cascade inside excel.)
Click to expand...

Actually for Macs, it is the system desktop.
You Mac guys got nothin' on us!!!
Click to expand...

Just wait until XL04 is released this spring... <g>
 
Back
Top