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:
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?
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:
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
