Fetch data from website with conditions

[the_rainmaker]

Hi,

I am trying to write a macro that can fetch data from a website.
To be specific, I am trying to write a macro that would automatically
pull phone numbers from www.canada411.ca given the postal code and name AND retrive ONLY IF THE ADDRESS MATCHES.
This is to be used with a spreadsheet that has address, postal codes, and names sorted by columns

I am very new with this so can anyone show me how I can start with this? Maybe a sample script that has been used or a link to different thread would be very helpful.

Thanks in advance!

 

[the_rainmaker]

bump

 

[John_w]

Try a web query. Using an example search for:

Name: John Smith
Location: Toronto, H2L 3K5

the resultant URL is:

http://www.canada411.ca/search/si/1/John+Smith/Toronto,+H2L+3K5

which means you can construct (using VBA) the search URL directly from the data in your Excel sheet without having to populate the search boxes on the web page. You can use this URL in a web query created by VBA.

Change the 'Results per page' to 50 and the URL changes to:

http://www.canada411.ca/search/si/1/John+Smith/Toronto,+H2L+3K5?pglen=50

which means it's more likely that the address you want to match is on that page. Even better, if you click 'Printer Friendly', the URL changes to:

http://www.canada411.ca/search/print/si/1/John+Smith/Toronto,+H2L+3K5?pglen=50

and there is less junk for the web query to import.

I would start by creating a web query with the macro recorder running to generate the VBA as a starting point for further development and go from there.