VBA GetOpenFilename does not work on Mac?

[JMaug]

Hi

I'm new in the forum and trying to learn VBA. I got this great code from a member here and I forgot to mention that I'm using Excel for Mac 2011.

When I try to run the macro, I get an error on the line in red in the code below. I did a research for the error and found the following:

"On a Mac, the filefilter is not working and it is not possible to select more than one file.
Also, ChDir is not working like in Windows to set the folder that will open with GetOpenFilename. But we can use a combination of VBA and Applescript."

Does anybody knows how to fix it? Below, it's part of the code.
Thanks,

-----------------------------------

Please Login or Register  to view this content.

[JMaug]

It seems many people have the same issue. I found this comment on the web. The person found the solution.

Now, where should I put that statement?

Thanks.

----------------------

Re: Excel 2011 Mac - VBA - GetData (path)
Hi,

I have finally managed to do it with the following method:

Please Login or Register  to view this content.

Hope it helps you out if you didn't find a way around it yet.

Luis

[JBeaucaire]

If that takes care of your original query, please select Thread Tools from the menu above and mark the thread as solved. Thanks.