Extracting Tax Rates from a Website

[Jlchumley]

Hello!

I am new to the forum as well as VBA. An employee that would create Excel macros for our company recently left, and I am trying to learn and develop VBA skills in his absence.

I am trying to create an Excel macro that can extract tax rates from the following website: "http://www.zip2tax.com/"
There is a search box in the middle, right side of the page to add a zip code.

I want the user to be able to enter any number of zip codes in column A of a spreadsheet and have the tax rate for that location to appear in column B.

However, I need to have the tax rate broken out by state and county. Once you Lookup the zip code, a box displaying the tax rate appears with an option to show the county and state break.
I would like for the state to be extracted into column B and the county tax rate to be extracted into column C.

Please let me know if anyone can help me with this task or provide some guidance.

Thank you!!

[berlan]

Hi Jlchumley, could you e.g. provide an workbook sample with zip codes or dummy data that you want to get tax rates from?

[Jlchumley]

The paperclick button is no longer visible. How can I attach a workbook without creating another post?

[Jlchumley]

Zip Code	State Rate	County Rate
30002
30004
30005
30008
30115
30055

[Jlchumley]

Is this okay?

[berlan]

Thanks I'll have a look at it.

[berlan]

Took longer than I thought to do this Try this for the state tax:

Please Login or Register  to view this content.

[berlan]

And this should work for the county tax:

Please Login or Register  to view this content.

[berlan]

Before I actually realised that you wanted it broken down and it got a bit trickier, I wrote the following:

Please Login or Register  to view this content.

[Jlchumley]

Thank you so much for this!!!!! I will study the code you wrote and reach out if I need something explained in detail. Again, thank you so much!!

[Jlchumley]

I just tried using the function in Excel (=GetCountyTax(30115)), and I got the following error message: "Error 400- Bad Request- Open Zip2Tax home page and try the request again (z2t:0.1)"

Please let me know how to properly run the code in Excel.

Thank you!

[Jlchumley]

Bump no response

[Jlchumley]

Bump no response