尝试通过makro在桌面上将工作表另存为.csv
我一直收到"Runtime error '1004‘Method 'SaveAs’of Object‘_'workbook’Failed“
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发布于 2020-10-07 23:37:37
您的文件路径不正确,可能驱动器是C:,因此请在前面添加C:并使用反斜杠。更正后的行:
wb.SaveAs Filename:="C:\Users\thomasduus\Desktop\1.csv", FileFormat:=xlCSV, CreateBackup:=False发布于 2020-10-07 23:39:40
我认为mac文件位置的工作原理类似于:
Wb.SaveAs "Macintosh HD:Users:thomasduus:Desktop:1.csv"https://stackoverflow.com/questions/64247363
复制相似问题