Getting Data from Web pages

[Karen]

Hi All
I have a task involving getting house council tax information from a
web page. Basically it involves entering a postcode followed by the
pricing band then council. The data is presented within the page and I
copy and paste the relevant part to notepad before importing into
Excel.Is it possible to automate this, I am looking for someone to
point me in the right direction and I will hopefully research the
rest.

TIA

Karen

 

[Nick Hodge]

Karen

What is the web address?....this should help us see if there is anything
that can be automated

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
(e-mail address removed)

 

[Karen]

Hi Nick
Thanks for responding... Here it is:
http://www.voa.gov.uk/cti/default.asp

Karen

 

[Nick Hodge]

Karen

Sorry, they are not using http to transfer the data in the url. If they
were doing this I was hoping we could append the query strings. I have even
tried trough Excel's normal web query interface, but no go...sorry

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
(e-mail address removed)

 

[jaf]

Hi Karen,
I would suggest contacting them. They may be able (and willing) to help.
Perhaps they can point to the data file so you can download it or send you a
copy.

Worst thing they can do is say no!

Please contact the Computerisation of the Valuation Office (COVO) Help Desk

By email on (e-mail address removed)

Or by telephone 01903 707850

The Help Desk is available 8 a.m. - 5 p.m. *
* Monday to Friday (excluding Bank Holidays)

 

[Karen]

Thank you Nick/John - I'll give it a try!!