really confused with web query

[jayd4wg]

I have a need to pull various bits of data from a web page. page in question is:
http://www.area-codes.com/exchange/exchange.asp?npa=412&nxx=596

obviously, the npa and nxx will change with relation to the value of a cell on the spreadsheet i'm working on, but the data I need to pull does not, nor does the target location on the spreadsheet. after the page comes up, i need to extract the County to range F64 and the Rate Center to cell L40
Further, i need to compare the data already populated on L40, and with message box prompt user to either replace or keep the data...this is a simple yes/no message box - i can handle this part, but i'm really stumped on how to get the data.

I'm provided with a phone number in cell y4, the NPA = left("y4",3) and NXX=(mid(y4,4,3))

I'll take any and all help i can get with this...i'm nearly out of hair to pull out.

 

[rdw72777]

Are you asking how to dowload the data from the web, how to get it to specific cells, how to determine matchs or messageboxes, or...?

I think the reason you have no replies is you don't provide sample data and its pretty unclear what you're asking for help on.

 

[jayd4wg]

okay, to get specific, i'm pulling data from a single cell on the worksheet, this cell is a phone number. Phone numbers are broken down as follows:

123-456-7890 = NPA-NXX-Station. I don't care about station number, and all rate center and pertinant information is based on NPANXX.

when you query the web page, you will get a return from values passed as NPA and NXX

Sorry this isn't as straight foward as some questions. I'm REALLY getting flusterd with the web query function