I have a workbook that we use on both Windows and Mac workstations. One piece of code creates an HTML file then opens that HTML file in the default browser. The section of code that launches the HTML file on Windows is below, but when this is run on a Mac the code sorta runs within a new Excel worksheet. The value strFName gets set to "C:\Users\user\AppData\Local\Temp\GoogleMaps.HTML" on Windows and "Machintosh HD:Users:user:Documents:GoogleMaps.html" on the Mac. I can confirm that manually opening the file works on the Mac, but getting it to launch outside of an Excel worksheet is just not happening.

Any thoughts about what sort of code would work in this situation? I already use an If/Then/Else function to identify the default file locations, I'm open to doing it for different launching solutions if that gets the job done.

     ActiveWorkbook.FollowHyperlink _
     Address:=strFName, _
      NewWindow:=True