|
发表于 2013-7-27 19:10
|
显示全部楼层
本楼为最佳答案
- Sub test()
- Dim n%, i%, j%, arr(), p$, f$
- n = Sheets.Count
- If n > 4 Then
- p = ThisWorkbook.Path & ""
- f = Sheets(n).Name
-
- ReDim arr(1 To n - 4)
- For i = 5 To n
- j = j + 1
- arr(j) = Sheets(i).Name
- Next i
- Sheets(arr).Copy
- Application.DisplayAlerts = False
- ActiveWorkbook.SaveAs p & f
- ActiveWorkbook.Close
- End If
- End Sub
复制代码
A.rar
(8.28 KB, 下载次数: 3)
|
|