Share via

FAIL: MacScript replacement for GetOpenFileName

Anonymous
2012-08-09T19:40:19+00:00

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:

http://bit.ly/OOdsQ1

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)

Microsoft 365 and Office | Excel | For home | Windows

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.

0 comments No comments

Answer accepted by question author

Anonymous
2012-08-10T11:59:50+00:00

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...

Was this answer helpful?

0 comments No comments

1 additional answer

Sort by: Most helpful
  1. Anonymous
    2012-08-10T14:24:43+00:00

    What?! You mean I have to read the WHOLE PAGE!!!

    Thanks.

    Was this answer helpful?

    0 comments No comments