Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Please Help...Multiple web queries and Macro help needed!
Ok to start off, I'm new here to the board and pretty advanced in Excel I'm going to explain my dilemma to the best of my abilities..if it need more explanation, please inquire, as I GREATLY need the solution to m problem to save alot of time! Here goes...and THANKS in advance!!! Lets say you are looking at the below information in excel: ----------------------------------------- _____A__________B______C_______D 1__Street#_____Street___Zip_____Phone ----------------------------------------- 2__1234_______Stone___75234 3__2345_______Rock____75234 4__3456_______Dirt ____75234 ----------------------------------------- I need a way to set up a web query to take a2,b2,c2 and do a revers address search on whitepages.com or a similar website...pic out th phone number from the returned information and place the phone numbe in d2...and repeat the process for a3,b3,c3 and so on.... I have played with whitepages.com and have set up a web query to do on line alone by creating an iqy file... here it is... ------------------------------------------------------------------------ WEB 1 http://www.whitepages.com/10001/sear...s?housenumber=["housenumber"]&street=["street"]&city_zip=["city_zip"]&state_id= Selection=3 Formatting=None PreFormattedTextToColumns=True ConsecutiveDelimitersAsOne=True SingleBlockTextImport=False DisableDateRecognition=False DisableRedirections=True -------------------------------------------------------------------------- The problem is...it isn't automated. I have to run the query eac time..select the three respective cells .. and then manually copy th number to the respective row in column D. I figure this is going to have to be a combination of a web query an macros to get the job done. If anyone can help...PLEASE help! Thank you again. Kinnet -- Kinnet ----------------------------------------------------------------------- Kinneth's Profile: http://www.excelforum.com/member.php...fo&userid=3631 View this thread: http://www.excelforum.com/showthread.php?threadid=56094 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Combing and Adding Data in Multiple Rows (Macro Needed) | Excel Programming | |||
Batch file to start multiple excel files with auto_open() macro. Delay code needed | Excel Programming | |||
Multiple queries | Excel Programming | |||
Executing multiple queries through a macro | Excel Discussion (Misc queries) | |||
Multiple Web Queries | Excel Programming |