如何在Mac Excel 2011中显示xlsm作为默认另存为文件类型的"另存为"对话框?
Application.FileDialog(msoFileDialogSaveAs)
在窗口中工作正常。但它在 Mac 中抛出错误
提前感谢!!
有些功能在MacOS上不起作用,请尝试将其作为替代方案:
Dim saveName As Variant
saveName = Application.GetSaveAsFileName()
If Not saveName = False Then
ActiveWorkbook.SaveAs CStr(saveName)
Else
MsgBox "File not saved!"
End If