CrunchMasterMatt
Board Regular
- Joined
- Jul 20, 2012
- Messages
- 123
Hi All, here is what I am trying to do:
1) Copy a value (a zip code) from a Named Range in my Excel 2010 worksheet called: Range("nr_ZipCode")
2) Open a web browser/then navigate to the web address listed below, and then input the Zip Code from my Named Range into the zip code box on the webpage (it's the ONLY input box on the webpage!).
Here is the web address:
Then programmatically press the GO button on the web page.
Does anyone know how to do this?!?!?
Thank you a million to anyone that does!!!
!!
1) Copy a value (a zip code) from a Named Range in my Excel 2010 worksheet called: Range("nr_ZipCode")
2) Open a web browser/then navigate to the web address listed below, and then input the Zip Code from my Named Range into the zip code box on the webpage (it's the ONLY input box on the webpage!).
Here is the web address:
Code:
http://gisatnrel.nrel.gov/PVWatts_Viewer/index.html
Then programmatically press the GO button on the web page.
Does anyone know how to do this?!?!?
Thank you a million to anyone that does!!!