Option Explicit
Sub ネユアィア昤?スノ嵭ノ()
Dim wb1, wb2 As Worksheet
Dim a As Integer
Sheets("ネユアィア朗」ー・).Visible = True
If Sheets.Count = 2 Then
Worksheets("ネユアィア朗」ー・).Copy after:=Sheets(Sheets.Count)
Set wb1 = ActiveSheet
wb1.Name = "1ネユアィア・
Else
Set wb2 = Sheets(Sheets.Count)
a = Left(wb2.Name, 1)
Worksheets("ネユアィア朗」ー・).Copy after:=Sheets(Sheets.Count)
Set wb1 = ActiveSheet
wb1.Name = a + 1 & "ネユアィア・
End If
Sheets("ネユアィア朗」ー・).Visible = False
End Sub
Sub チ昻豎ィア・)
Dim wb() As Workbook
Dim x As Integer
Dim y As String
Application.DisplayAlerts = False
For x = 1 To Sheets.Count - 2
y = Sheets(x + 2).Name
ReDim wb(x) As Workbook
Sheets(x + 2).Copy
Set wb(x) = ActiveWorkbook
wb(x).SaveAs ThisWorkbook.Path & "\" & y & ".xls"
wb(x).Close True
Next x
Application.DisplayAlerts = True
End Sub
兰版主,如果你看了54楼的,这个就不用看了,我不知道你要看哪样的。54楼是一个压缩文件,又发了个个代码的。
Option Explicit
Sub 日报表格式生成()
End Sub
Sub 另存报表()
Dim sh As Worksheet
Sheets("日报表模板").Visible = True
Sheets("日报表模板").Copy after:=Sheets(Sheets.Count)
Set sh = ActiveSheet
sh.Name = Sheets.Count - 2 & "日报表"
Sheets("日报表模板").Visible = False
Sheets(1).Select
End Sub
--------------------------------------------------------------------------------------------------------------------
Sub 分表()
Dim wb As Worksheet
Dim x As Integer
For x = 1 To Sheets.Count - 2
Sheets(x & "日报表").Copy
Set wb = ActiveSheet
wb.SaveAs ThisWorkbook.Path & "/" & wb.Name & ".xls "
ActiveWorkbook.Close True
Next x
End Sub