excel - Applescript 不会打开 Excel 2011 工作簿

Question

有人可以告诉我以下applescript有什么问题吗

set sourceFile to (choose file with prompt "Choose source files" of type {"XLS6", "XLS7", "XLS8", "XLS", "TXT"} with multiple selections allowed without invisibles)
tell application "Microsoft Excel"
-- activate
open workbook workbook file name sourceFile
end tell

我收到以下错误

error "Microsoft Excel got an error: Can’t continue open workbook." number -1708

如果我对单个文件路径进行硬编码，则该脚本可以工作，因此问题必须在 set sourceFile 行中，但我需要能够选择一个文件，因为它并不总是相同的。

Answer 1

尝试这个:

set sourceFile to (choose file with prompt "Choose source files" of type {"XLS6", "XLS7", "XLS8", "XLS", "TXT"} with multiple selections allowed without invisibles) as string
tell application "Microsoft Excel"
open sourceFile
end tell