Applescript 语法错误,使用 excel "open workbook" 命令



下面是相关Excel库的截图

下面是错误的截图

下面是我的代码:
on saveExcelAsPDF(documentPath, PDFPath)
    set tFile to (POSIX path of documentPath) as POSIX file
    tell application "Microsoft Excel"
        set isRun to running
        set wkbk1 to open workbook workbook file name tFile
        alias PDFPath
        save workbook as wkbk1 filename PDFPath file format PDF file format with overwrite
        close wkbk1 saving no
        if not isRun then quit
    end tell
end saveExcelAsPDF

当我尝试编译时,我得到一个错误警报,上面写着"语法错误;期望的行结束等,但发现标识符",并且第二个"工作簿"单词在第6行突出显示。我做错了什么?

谢谢!

我明白了!当我使用'tell application "Microsoft Excel"这一行时,它指的是Windows版本的Excel(通过parallels桌面运行),而不是Mac版的Excel。我将这一行替换为'tell application "/Applications/Microsoft Excel。

最新更新