|
楼主 |
发表于 2012-10-22 19:31
|
显示全部楼层
hwc2ycy 发表于 2012-10-22 19:11
我又修改了一下代码,虽然不十分明白是为什么,但还终于调试成功了,谢谢大神,膜拜你,收徒弟不?拜师啊大神,改过地代码如下:
Sub 去除公式连接()
Dim i As Integer
Dim y As Integer
Application.ScreenUpdating = False
'关闭警告信息和对话框,默认情况下重名文件会被覆盖
Application.DisplayAlerts = False
y = InputBox("请输入表格数量")
For i = 2 To y + 1
Sheets(i).Select
Columns("A:M").Select
Selection.Copy
Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
:=False, Transpose:=False
Application.CutCopyMode = False
Columns("A:D").Select
Range("D1").Activate
Selection.Delete Shift:=xlToLeft
Columns("J:K").Select
Selection.Delete Shift:=xlToLeft
Sheets(i).Copy
'ActiveWorkbook.SaveAs Application.ActiveWorkbook.Path & "\" & Sheets("i").Name & ".xls" '(工作表名称为文件名)
Debug.Print ThisWorkbook.PATH & Application.PathSeparator & ThisWorkbook.Sheets(i).Name & ".xlsx"
ActiveWorkbook.SaveAs Filename:=ThisWorkbook.PATH & Application.PathSeparator & ThisWorkbook.Sheets(i).Name & ".xlsx", FileFormat:=xlOpenXMLWorkbook
'ActiveWorkbook.Close True, Filename:=ThisWorkbook.Path & Application.PathSeparator & ThisWorkbook.Sheets(i).Name & ".xlsx"
ActiveWorkbook.Close
Next
Application.ScreenUpdating = True
Application.DisplayAlerts = True
End Sub
|
|