下面是相关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。