will89 wrote:Hi Kiloran,
Excel for Mac does have VBA, but I think you're right in suggesting that a basic macro might work better.
I've tried downloading the linked file, but I can't seem to make it work even on my Windows PC, do you need to copy and paste the code in VBA that's assigned to the sheet and then create a button in my own file that uses that code? I couldn't see a separate macro module in the file I downloaded. Basically, no idea how to get the functionality from your file into mine.
OK, let's stick with Windows for the moment (I don't have access to a Mac). Download the file simple_yahoo_price_scrape_v1-1.xls and open it. You should see a button "Get Yahoo Prices". Click on that and the prices in column B should update. If that is OK, you could leave the sheet as-is and use the VLOOKUP function to extract the data to a new sheet or workbook.
If that works OK, then try it on the Mac and let us know if it works.
If you want to use the VBA code in another workbook, open the Visual Basic editor and you should see the code attached to Sheet1. You can copy and adapt the code as you wish.
will89 wrote:Apologies if I'm being stupid...
Hey, I've got a monopoly on that.