|
请教下大师傅,我有一个另存的问题,比如一个工作簿中有多个工作表,前四个工作表1. 2. 3. 4不需另存 其余各自命名为301djr01 301djr02 ~~
每表个中I3 为各自名字 301djr01 301djr02 ~~ I5格是路径 比如对应 c:\301\301djr01.prt d:\301\301djr02.prt ~~~~
如何另存为各自路径下为 301djr01.xls 301djr02 .xls ~~~~谢谢
- Sub 批量另存()
- Dim i As Byte
- On Error GoTo ErrorHandler
- Application.ScreenUpdating = False
- Application.DisplayAlerts = False
- For i = 5 To Worksheets.Count
- Worksheets(i).Copy
- MkDir Range("i5").Value
- ActiveWorkbook.SaveAs Filename:=Replace(Range("i5").value, ".prt", ".xls"), FileFormat:=xlExcel8
- ActiveWorkbook.Close True
- Next
- Application.ScreenUpdating = True
- Application.DisplayAlerts = True
- MsgBox "OK"
- ErrorHandler:
- Debug.Print Err.Number & Err.Description
- Resume Next
- End Sub
复制代码
|
|