首页
学习
活动
专区
圈层
工具
发布
社区首页 >问答首页 >Excel - "Runtime error '1004‘Method 'SaveAs’of Object‘_'workbook’Failed“Macbook

Excel - "Runtime error '1004‘Method 'SaveAs’of Object‘_'workbook’Failed“Macbook
EN

Stack Overflow用户
提问于 2020-10-07 23:30:49
回答 2查看 293关注 0票数 1

尝试通过makro在桌面上将工作表另存为.csv

我一直收到"Runtime error '1004‘Method 'SaveAs’of Object‘_'workbook’Failed“

代码语言:javascript
复制
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
EN

回答 2

Stack Overflow用户

发布于 2020-10-07 23:37:37

您的文件路径不正确,可能驱动器是C:,因此请在前面添加C:并使用反斜杠。更正后的行:

代码语言:javascript
复制
wb.SaveAs Filename:="C:\Users\thomasduus\Desktop\1.csv", FileFormat:=xlCSV, CreateBackup:=False
票数 0
EN

Stack Overflow用户

发布于 2020-10-07 23:39:40

我认为mac文件位置的工作原理类似于:

代码语言:javascript
复制
Wb.SaveAs "Macintosh HD:Users:thomasduus:Desktop:1.csv"
票数 0
EN
页面原文内容由Stack Overflow提供。腾讯云小微IT领域专用引擎提供翻译支持
原文链接:

https://stackoverflow.com/questions/64247363

复制
相关文章

相似问题

领券
问题归档专栏文章快讯文章归档关键词归档开发者手册归档开发者手册 Section 归档