Populating a Zip Code into a webpage from Excel/VBA

mattb1 — Sat, 23 Mar 2013 23:34:39 GMT

Hi All!

I am an intermediate Microsoft Excel developer, I'm good with Excel/VBA, but my weakness is in writing & receiving data from webpages. I need to figure out one simple task... I'm hoping someone can help me with this...

I literally just need to enter a zip code (contained inside my worksheet in Excel) into a webpage (I know how to open the web browser and navigate to this webpage already), I just dont know how to code it from there. Then, once the Zip Code is input into the webpage, I need to programmatically press the 'GO' button on the webpage? Check it out, here is the webpage:

http://gisatnrel.nrel.gov/PVWatts_Viewer/index.html

The above webpage is powered by ESRI, which links back to this forum, so I am hoping someone here knows how to do this?

The data I am looking to get back from the webpage after the GO button executes programmitacally, is located inside the "40km Monthly Grid Cell" (there are 2 Grid Cells which are data boxes regarding the zip code entered). They appear with data in them, I need the data inside the "40km Monthly Grid Cell".

Within that Grid Cell, you will see a line called:
"Annual ( kWh / m2 / day ):" To the right if this, you will see a number, it will be a number between 4.5 and 6.5 and it represents the Peak Sun Hours for that Zip Code.

That's all I need!!??!? Is there anyone who can help me with the code to do this?

Re: Populating a Zip Code into a webpage from Excel/VBA

EricBowman — Sun, 24 Mar 2013 17:22:51 GMT

Hi All!

I am an intermediate Microsoft Excel developer, I'm good with Excel/VBA, but my weakness is in writing & receiving data from webpages. I need to figure out one simple task... I'm hoping someone can help me with this...

I literally just need to enter a zip code (contained inside my worksheet in Excel) into a webpage (I know how to open the web browser and navigate to this webpage already), I just dont know how to code it from there. Then, once the Zip Code is input into the webpage, I need to programmatically press the 'GO' button on the webpage? Check it out, here is the webpage:

http://gisatnrel.nrel.gov/PVWatts_Viewer/index.html

The above webpage is powered by ESRI, which links back to this forum, so I am hoping someone here knows how to do this?

The data I am looking to get back from the webpage after the GO button executes programmitacally, is located inside the "40km Monthly Grid Cell" (there are 2 Grid Cells which are data boxes regarding the zip code entered). They appear with data in them, I need the data inside the "40km Monthly Grid Cell".

Within that Grid Cell, you will see a line called:
"Annual ( kWh / m2 / day ):" To the right if this, you will see a number, it will be a number between 4.5 and 6.5 and it represents the Peak Sun Hours for that Zip Code.

That's all I need!!??!? Is there anyone who can help me with the code to do this?

Matt,

I'm not a programmer, but you will need access to the REST endpoint and a feature access service to be able to make any changes into a website like you are thinking about doing. If you don't have those, then you will have just a web application with a cached or dynamic map services.

Hope this points you in a better direction. You may want to post over in the Web API forums as well.
Eric

topic Populating a Zip Code into a webpage from Excel/VBA in ArcGIS for SharePoint Questions

Populating a Zip Code into a webpage from Excel/VBA

Re: Populating a Zip Code into a webpage from Excel/VBA