Using SAP GUI from Excel on MacOS

I have large data sets that I manipulate in excel and copy paste manually to SAP using a variety of different t-codes. I am looking to automate this by running SAP GUI from my excel to copy and paste the data in specific fields. What I am struggling with is getting the initial connection from Excel VBA to SAP. I have gone through several of the stack overflow questions on this topic but I am not finding any good answers for Mac OS specifically. Please let me know what code I can use to control SAP from Excel VBA. Thank you!