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.)
Hi there,
After watching your tutorial i could only get the web data but could not do the last step which was to actually put it into the cell of my choice. How do you actually extract the data and place it in the cell you wanted it in Excel spreadsheet itself?
Also is there a way to have the web data to automatically refresh itself ie every 24hours or daily?
thanks!
Paste the code that you are working with in your workbook, I'm assuming it is a little different now than what was in the tutorial.
Otherwise, just get the data however you want and then use something like Range("A1").Value = YourData
And here is how you make code run at intervals:
