weather

Hi dear all, I have an error while importing data into acess database showing error 3349.please check the screenshot attached.

Hello, I need help trying to get the 1st line of the following 10-day forecast. Here is my code to get the forecast for Miami, FL on Weather.com. I am not able to get the current date or the first date in the summary. Please help. Thanks and take care. Sub MiamiWeather() Dim ieObj As...

Been having hard time solving this question.I got it wrong and i believe the workings used is the cause of it. Question 1 The following file describes the situation faced by a landscaping company, 'Landscaping Solutions'. If there is great weather, the company takes the following hours to...

He Guys, I am trying to read/import(actuel) weather data into an excel sheet. So i surfed the web for quite some time, but i am hoping you can help me out. I have some experience with vba, but not with reading data into excel. So i will explain what my idea is, I want to read/import actuel...

Hi, I'm in need of some help in creating a spreadsheet and graph for my business. I haven't used Excel since I left school so I'm a little bit rusty, but I'm a fast learner. I work in a pub with a large beer garden. I want to create a spreadsheet and line graph that show the relationship...

Hi There, I have all text in a cell example Cell A1 Today is hot Last week was cold Today's weather is 18 Next week is 20 I need a VBA code that searches the cell via instring search for example searches "Today's weather" and will return the whole line "Today's weather is 18" which then i will...

hi Need help with the following; it is clearly beyond me ! I have an API for openweather.org I can Paste the API info into a Browser and get a response back that looks like this; Webinfo...

I have an excel file I use to make my daily task sheet. I wanted to have it include the daily weather forecast with the weather icon, the high and the low. I have worked on some of how to make this work but I'm hitting a road block getting the image to download into the correct locations. I...

Has anyone successfully brought in Noaa NWS XML data into powerpivot ? National Digital Forecast Database XML/SOAP Service - NOAA's National Weather Service NOAA's National Weather Service National Digital Forecast Database XML/SOAP Service - NOAA's National Weather Service i can get the SOAP...

Hi, I am trying to incorporate a Weather forecast into an excel sheet. Is there any code that can do this? thanks

Hello, Basically I have a list of zipcodes and I would like to create a webquery which will pull back the average temperature, rainfall, snowfall for a week (last week or other historical weeks). I found a website which has this info: http://www.wunderground.com/history/ and I can put in a...

Hi I used wolverineb’s formula http://www.mrexcel.com/forum/showthread.php?t=458054&highlight=wind+direction) in reverse to calculate the wind direction in degrees from wind direction in text. The lookup table is This works well after a little tweaking. The formula I am using is...