Creating something that will import weather data into excel sheet
I'm a fairly inexperienced programmer in general. I'm currently working on a project where we are modifying an existing application. This application is fed data from excel sheets. We are attempting to get live weather data for the application. The weather data is coming from web pages that are url queries to NOAA, which can be seen here:
Excel has a tool that will do this, and refresh automatically. Unfortunately the data isn't presented in a way for this to be done properly via that method, and the URL will change daily (the fs20110322 represents the date), which also isn't something Excel will do as far as I know. I was wondering if anyone would have an idea as to how we would go about creating something in Java (or any other language) that would put us on the right track.