How do I open URL in Chrome on a Mac?

How can I do this on a MAC?

Function SendURLToChromex()
    Dim chromePath As String
    Dim MyURL As String
    MyURL = "www.yahoo.com"
    chromePath = """C:\Program Files (x86)\Google\Chrome\Application\chrome.exe"""
    Shell (chromePath & " -url " & MyURL & " ")
End Function

No idea as here it's the Excel for Windows section !

CK76 - When I try to run the code, on step "MacScript S", I receive:

Run-time error "5": Invalid procedure call or argument

Any ideas on why this would be?

Thanks very much for responding. I took a look at the link - Ugh - I can't believe how much is involved. I'm not a MAC guy and was trying this to make my macros work on a mac for a co-worker, but it seems a little involved for me. I wish there was an easier way (or that I was more familiar with a MAC).

Can't you just use ThisWorkbook.FollowHyperlink ? Why does it have to be chrome?

That's an interesting idea. In my original post above I'm showing the URL as yahoo.com. But in reality, it's actually a URL that downloads a file. Internet Explore doesn't actually download the file until you hit save, but Chrome will download it to your Download directory. I then run a macro that opens the latest file in the Download directory and I can manipulate that file then. It seems using the FollowHyperlink doesn't download the file when you send it the URL.

So to re-cap, what I'm able to do in Windows is send a URL to Chrome that downloads a file, then open that file from the download directory. I want to be able to do that same functionality on a MAC.
Thanks!

Hmm, it's not working for me - even on Windows. Yes, I can send a URL and it will navigate to a URL, but if the link is to download a file, it does not do that.

Have you tried this: https://stackoverflow.com/questions/...el-vba-for-mac

You may need to tweak it a bit for saving the file though

Well, I worked on it again today with a MAC, and the Followhyperlink worked!! Mac sometimes causes issues because of permissions, but it looks like it works great! Thanks you guys!