A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
Take a look at item 5 just under the code in the link that you posted - it tells you exactly what format code(s) to use...
This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
After looking around a bit, I found a number of forums/sites that tout a MacScript() replacement for Application.GetOpenFileName(). They all appear to have originated with this:
As far as it goes, the script works. The problem is this only works with .xls files (com.microsoft.Excel.xls). I have found no documentation saying if there are other identifiers for .xlsx, .xlsb, etc. It seemed logical to try com.microsoft.Excel.xlsx but that doesn't work. Anyone know how to make it work with recent file types?
Mac OS 10.6
Office 2011 (with all latest updates)
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
Take a look at item 5 just under the code in the link that you posted - it tells you exactly what format code(s) to use...
What?! You mean I have to read the WHOLE PAGE!!!
Thanks.