Uploading an Excel File with Macros in Google Sheets

I recall looking at this issue once. If I remember correctly, Google sheets uses Javascript as its macro language. So, getting your macros to work in Google sheets involves converting your macro(s) to javascript in a google sheets project. As I did not know javascript, that was as far as I got.

Perhaps this will get you started: https://support.google.com/docs/answer/2942256?hl=en