So, letting a friend try my code on his Mac, without the xsl stylesheet parameter, he got this error
Run-time error '2004'
Method 'OpenXML' of object 'Workbooks' failed.
Which answers my #1 question.
Thanks for the contributions @timwilliams and @Haluk.
I will start exploring options like Power Query.