Web query from cell value

[hazzaska]

Hi

I want to pull in some results from a web query but change the date by entering the date of the query in a cell (ae1) from the following url and refresh destination cell A1

http://www.paddypower.com/results/mu...ate=2017-04-10

Is this possible with a macro or similar? I have googled it and can't get any of the solutions to work

Thanks

[Marc L]

Hi !

Maybe ! 'cause I can't access this site, I got a Restricted Territory Message !

A must read : Web Scraping tutorial …

[AB33]

Here is similar thread you could follow.
https://www.excelforum.com/excel-pro...ml#post4634797

if you want auto fresh, you need to use excel's import function to import it as a table.

[hazzaska]

I have got it to work with a macro but how do i overwrite the populated cells and not add a new connection everytime?

[AB33]

Please wrap your code before I post the code.

This is the correct code, but there is an issue with dates. The code loops from B2 to down column B and pick up the dates for each loop.

I put all dates in column B, but these dates are not recognised as dates and thus get a wrong table.
I still looking at it.

Please Login or Register  to view this content.

[AB33]

When I convert the dates in column B to text (which should match the dates in the site), it seems to work.

[hazzaska]

Hi i cant seem to get that to work, my macro works but adds a new connection and also pastes into adjacent columns not A1 can my macro be edited to just overwrite the data populated in a1 etc?

Thanks

[AB33]

I do not know what do you mean by "adds a new connection". The code does not paste in A1, each loop (Table) is pasted into next empty row in column A. Where do you want to paste the imported table? If you want to delete the connection:

ActiveWorkbook.Connections(1).Delete