'Created By Randy Austin of SendLink As String, StartLink As String, EndLink As String, HeaderName As String, SendID As Stringĭim ReportedBy As String, EmailAdd As String, IssType As String, IssDesc As String 'This Macro Requires Reference to 'Microsoft XML, v6.0' (VBA Editor > Tools > References, find & select from list) Really appreciate if someone can help me to solve this problem. Of course, if any one of you have better idea on how to send the data to Google sheet which works for both Window and MacBook, please let me know by leaving a comment. In case someone needs the Youtube video, here is the link: I posted the code below and hope to get some advice on what should I change so that it works for both Window and MacBook.

I'm not sure how to solve this issue as I'm relatively new to VBA and I'm not coming from a technical background with strong understanding on 'server'.

After doing some research, I found out that it is actually the problem of MSXML2.ServerXMLHTTP60 which doesn't exit in MacBook (if I'm correct). When I run the Macro in MacBook, it will show me that 'Can't find project or library'. The method works perfectly in Window PC but it have some problem with MacBook. I found a tutorial on Youtube showing me how to do send the data to Google sheet using VBA.

Transfer google sheets to excel