Open xlsx with macro

[bloomingcarrot]

Hi All!


I've found this code that I have assigned to a button to open files. However, the majority of files I need to open are xlsx extension and when I try to add that type I am unable to open them - they are grayed out. Can someone help me with what I am doing wrong or need to change within in the code to allow it to open .xlsx files?

Any and all help is greatly appreciated. Thank you!!

Please Login or Register  to view this content.

[Demeter]

Hi,

Think mac works a bit different then Windows and looking at you code it comes from Ron's website.
But i would still like you to check the contents on following link:
http://www.rondebruin.nl/mac/section3.htm

And then especially page:
http://www.rondebruin.nl/mac/mac015.htm

Scroll down or use search for the .xlsx file format.

reg.
Demeter

[bloomingcarrot]

I found my answer there! Had to add ""org.openxmlformats.spreadsheetml.sheet"" to my code. Thanks so much!!