lhardee
01-15-2010, 05:48 PM
Hello,
I've been searching for a way to fetch data from a website and have come pretty close but not found exactly what I'm looking for.
I have a spreadsheet with about 500 addresses that I would like to search for from a database at the following website:
http://gwinnetttaxcommissioner.manatron.com/Tabs/ViewPayYourTaxes.aspx
On the webpage there is a drop down box with a few selections of which I would like to choose Street Name. Next to it is a textbox. This is where the names in my column A would be entered. I've found that the search feature is very specific and will not return a query unless entered correctly. Just street names leaving off Dr, Ave, Blvd...etc. works perfectly.
To my question:
Is there a way that I can have the results displayed in the following columns next to the street name in column A ? If so, could someone provide code that does this?
Thanks for you assistance.
lhardee
I've been searching for a way to fetch data from a website and have come pretty close but not found exactly what I'm looking for.
I have a spreadsheet with about 500 addresses that I would like to search for from a database at the following website:
http://gwinnetttaxcommissioner.manatron.com/Tabs/ViewPayYourTaxes.aspx
On the webpage there is a drop down box with a few selections of which I would like to choose Street Name. Next to it is a textbox. This is where the names in my column A would be entered. I've found that the search feature is very specific and will not return a query unless entered correctly. Just street names leaving off Dr, Ave, Blvd...etc. works perfectly.
To my question:
Is there a way that I can have the results displayed in the following columns next to the street name in column A ? If so, could someone provide code that does this?
Thanks for you assistance.
lhardee