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.
Thanx
Posted by Michael Liu on September 05, 0100 12:00 PM
Try the open command:
Workbooks.Open Filename:="http://www.weather.com/weather/us/zips/10166.html"
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.
