try this url for vba turoial

http://www.vbtutor.net/vbtutor.htm


"CompPro" wrote in
message ...

Chuck,

Thank you for replying to my message. Below is a suggestion from a
user group I visited. Is this an example of Visual Basic, or can this
be done in excel? I couldn't figure out how to insert it based on the
traditional macros in excel.

Option Explicit
Sub testme()

Dim wks As Worksheet

For Each wks In ActiveWorkbook.Worksheets
wks.Copy 'to a new workbook
With ActiveSheet
Parent.SaveAs Filename:="C:\temp\" & .Name, _
FileFormat:=xlWorkbookNormal
Parent.Close savechanges:=False
End With
Next wks

End Sub

Make sure C:\temp\ already exists (or change the code to point at an
existing
folder)


--
CompPro
------------------------------------------------------------------------
CompPro's Profile:
http://www.excelforum.com/member.php...o&userid=37076
View this thread: http://www.excelforum.com/showthread...hreadid=568009