How to link excel and a website

--------------------------------------------------------------------------------

Hi,

Everyday we need to update data that is on a website.(www.gocompare.com) to an excel sheet I maintain. Is it possible to write a VBA code to automate this process?

eg: it should refer the data relevant for today and insert the number in the excel sheet. What I currently do is manually inserting it.
If I can automate it, then by the press of a button, I can automate it when the data is released for tomorrow.

Can you please let me know whether VBA can do this. If not is there anyother way I can do this?

Many thanks,

hi..thank you for the reply...I will try and amend the code and see if it works.
Else shall I attach attach my sample excel sheet and the screenshot of the webpage for you to get a better idea?

Thanks once again

You'd better use the builtin Excel-facility Webquery.
No need for VBA.

Menu Bar/Data/external data/webquery. And use the wizard.

Thanks for the reply. But I get the following error. Do you know how to avoid

Use of default namespace declaration attribute in DTD not supported.

Please let me know

thanks

In the attachment I implemented a webquery for gocompare.

Is there a way to work around the error I am getting?

I don't get any errors.
But you can try this macro in a new worksheet:

Please Login or Register  to view this content.