尝试通过宏将工作表另存为桌面上的 .csv 文件。我一直收到“运行时错误 '1004' 对象 _'workbook' 的方法 'SaveAs' 失败”的提示。
Sub Export()
Dim wb As Workbook
Dim sht5 As Worksheet
Dim r As Long
Dim LastRow As Long
Set sht5 = ThisWorkbook.Worksheets("ExportCsv") 'Sheet to export as CSV
Set wb = Application.Workbooks.Add
sht5.Copy Before:=wb.Worksheets(wb.Worksheets.Count)
LastRow = Cells(Rows.Count, "A").End(xlUp).Row
For r = LastRow To 1 Step -1
If Cells(r, 10) = 0 Then
Rows(r).Delete
End If
Next r
Application.DisplayAlerts = False 'Possibly overwrite without asking
wb.SaveAs Filename:="/Users/thomasduus/Desktop/1.csv", FileFormat:=xlCSV, CreateBackup:=False
Application.DisplayAlerts = True
wb.Close SaveChanges:=False
End Sub
C\
(或者你的根目录引用)并且你的斜杠反了。 - urdearboy:
作为分隔符? - urdearboy:
可以停止显示运行时错误框,看起来它会通过整个过程,但它不会覆盖我桌面上现有的 1.csv 文件。 - Thomas