QUERY WEB from URL that change date every day

[robgiuss]

I have to solve this problem.

I import every day in a worksheet data from this URL

http://www.lottomaticaitalia.it/10el...?data=20140327

Every day the final part of this URL change and show the current date.

During the day the QUERY WEB refresh automatically every 1 minute.

If I use the function in Excel IMPORT FROM WEB I have to change it manually every day.

I save the function as follow :

WEB
1
http://www.lottomaticaitalia.it/10el...?data=20140328

Selection=EntirePage
Formatting=None
PreFormattedTextToColumns=True
ConsecutiveDelimitersAsOne=True
SingleBlockTextImport=False
DisableDateRecognition=False
DisableRedirections=False

I don't want change the URL every day but I want automatize this operation !

Please HELP ME ! Thanks !

[Fotis1991]

Pls take some minutes and read forum rules before you post again because....

Welcome to the Forum, unfortunately:

This is a duplicate post and as such does not comply with Rule 5 of our forum rules. This thread will now be closed, you may continue in your other thread.

Thread Closed.