How to automate getting information from the web, e.g., temperature, daily ?

what you should do is record yourself doing a web query, then go to weather.com and type in your zip code into the prompt. Next import the table and just delete all of the stuff you don't need when you put it into excel, then you will be left with temp, wind, etc. if you want or you can just delete everything except the temp. You will then have a working macro to go get the temp of that day. mine looked like this.

Please Login or Register  to view this content.

Let me know if this works for you.

hmm. I know you can call macros at certain times of the day, although i believe that you would have to have your workbook open at that time of day in order for it to run. I think the code for that would go something like this. If your macro was named, like mine Macro 1...

Please Login or Register  to view this content.

This macro only works in the ThisWorkbook vba section and not a module. Also, it will only work after you save the workbook with this macro and then reopen the macro. This is because of the fact that the workbook being opened triggers this macro to run. As it is now, this macro will run at 9:00 PM. The time is always local with this macro.

I am not sure if you can automate it to open excel and run the macro at a certain time. I will do some digging, though it hardly seems possible since i believe that you need excel open to run a macro to begin with.

---------- Post added at 09:04 PM ---------- Previous post was at 08:54 PM ----------

rob,

Take a look at this thread, you may be able to take something away from this to help you make the macro self sustaining.

http://www.excelforum.com/excel-prog...me-of-day.html

All i did was put this "open excel and run a macro at a certain time of day" into my google browser and a lot of things returned. Hope this helps. Let me know if you do run into anymore problems.

Rob,

Look at my previous post if you have not already, there is a link that may help you make your program self sustaining since it is being opened daily, this link and google search should help you do the trick.