This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(128, 8%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
I'm looking to make a program like this one found on youtubehttps://youtu.be/iSlBE3CWg5Q . The program pulls data from yahoo finance and puts it in an excel sheet when you click the refresh button. The problem is that I am using Excel 2016 on my Mac and from what I have found out you cannot use WinHttpRequest on Mac. Does anybody know a different solution to make the program work? If so how do I enter it in the program? This is my first time ever coding so I am very new to all of this. Thanks.
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.
You might investigate the Stock Connector app (free) discussed in this Q&A. I'm not sure whether or not it is robust enough for your purpose.
That's correct. WinHttpRequest does not wok on mac versions. You need to do this with VBA. I'm not sure if anyone has published a solution. But, if you contact me off line (my email address is in my profile - just click on my name) and supply some samples and what you intend to do, I will be happy to provide a price quotation for a VBA solution.