This used to work, now in v16.76 I get a parameter error. Anyone else see changes in the open file - with parameters to open files other than “.xlsx”?
tell application id “com.microsoft.Excel”
activate
open text file filename strSourceFile data type delimited field info {{1, text format}} use other 1 other char “;”
end tell
You script did not work for my environment (Excel 16.78+macOS 13.6.1).
But it seems to be able to open a csv.
set strSourceFile to choose file of type {"public.comma-separated-values-text"}
tell application id "com.microsoft.Excel"
activate
open strSourceFile
end tell