This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(128, 8%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
this script worked with v 11.5.9; doesn't work with v 15.15
tell application "Microsoft Excel"
open file "Macintosh HD:Users:sam:Desktop:pantrash:newtargetinv.xls"
tell workbook 1
tell sheet 1
save in "Macintosh HD:Users:sam:Desktop:pantrash:newtargetinv.csv" as CSV file format
end tell
close without saving
end tell
end tell
the error is error "Microsoft Excel got an error: Parameter error."
the parameter in question seems to be 'CSV file format'.
does anyone know how to fix this?
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.
Answer accepted by question author
A lot of stuff is "broken" with Excel 2016. Use the smiley face in the upper right of the menu bar to tell Microsoft of the problem. Then hope that it will be addressed in a future update.
> this script worked with v 11.5.9; doesn't work with v 15.15 <
Mac Excel version 11.5.9 was part of Office 2004.
Do you know whether your script worked in Mac Excel 2008 or in Mac Excel 2011?
The current version of Mac Excel 2016 is 15.16.
Since Mac Excel 2016 is an evolving product, I suggest you try the most recent update.