Hi,
I am currently making an Excel spreadsheet with daily corn prices of local cooperatives and processors. I have no experience with VBA coding and might be in over my head but I used your tutorial to pull the daily price off there websites. I have a few questions.
First, how do I take those prices and put them in the spreadsheet and not the Message Box?
Second, what do I have to change to pull more than one price off the website, or do I just create a new macro for each price?
Below is the video I watched:
https://www.teachexcel.com/talk/3459/vba-macro-to-import-web-data-into-excel-how-to-create-a-list-of-stock-price
Any help would be great. Thanks