Excel VBA Course
Excel VBA Course - From Beginner to Expert

200+ Video Lessons
50+ Hours of Video
200+ Excel Guides

Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)

View Course

VBA Macro to Import Web Data Questions

0

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

Answer
Discuss



Answer the Question

You must create an account to use the forum. Create an Account or Login