MrExcel Publishing
Your One Stop for Excel Tips & Solutions

How to import data from a web page using a macro

Posted by Jan on September 05, 2000 7:49 AM

How can you get data from a website and paste it in a cell in Excel. I tried to do this with a macro that recorded what I did, but it didn't work. The meaning is everytime I press a command button the data should be updated from the website.

Posted by Michael Liu on September 05, 0100 12:00 PM

Try the open command:

Workbooks.Open Filename:=""

I use this in a macro to get the latest weather conditions and forecasts, parse
out the important info, and then text message to a cell phone.
At work, I use this method to get query results from our internal web database server.