Importing Web Data through VBA Macro into Excel


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?





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:

Run Macro at Set Intervals


Answer the Question

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