itsrich
Board Regular
- Joined
- Apr 13, 2009
- Messages
- 73
- Office Version
- 365
- Platform
- Windows
I would like to enter the NPA NXX, then click/run macro, and it go to http://www.telcodata.us/search-area-code-exchange-detail with the NPA NXX, put the NPA NXX in the search filed, execute the search, return the LATA and Switch Name in their own fields to be used as search criteria in the same spreadsheet.
I can do this manually, but I wish to autmate this to speed up the task.
to have actual data to work with, NPA = 574, NXX = 457. It should return LATA = 332 and Switch Name = Syracuse.
With your help in creating this code, I will be able to modify it for other searches!
Windows 7, Excel 2007, IE 8.x
This data is used in the Telco industry.
Thanks - Rich
I can do this manually, but I wish to autmate this to speed up the task.
to have actual data to work with, NPA = 574, NXX = 457. It should return LATA = 332 and Switch Name = Syracuse.
With your help in creating this code, I will be able to modify it for other searches!
Windows 7, Excel 2007, IE 8.x
This data is used in the Telco industry.
Thanks - Rich