Import Data from a website consistently

Hello excel and VBAīs masters....

This is my first post, so Iīm Edaurdo from Portugal and Iīm a noob with VBA coding.... I downloaded some tutorials from the " Excel Useful Links ", but I need some help quickly (if you have the time)..... I would thank you, in advance, for any help you could give me.....

So, the problem is this:

- I already try with excel (data-from web-select the box(es)-OK), and I extract the data (table) that I need. So far, so good....

- Later (about 3-4 days), when I do the refresh the tables are all wrong. Then I go to the connections links and the box(es) previously selected desapear or other box(es) are selected.

So I donīt know what I do wrong or it just donīt work like this.

The site is www.soccerstats.com (do you know??)....

I would like to import the data from some tables, but I donīt know if I do direct from excel or from VBA code.....


Many thanks, in advance, for any help you could do.....

Best regards,
Eduardo

Hello, sorry the wait.... But in work I donīt have the possibility to upload files.....

http://speedy.sh/TkVRR/Connections-Lost.xlsx

The link is here, to download the file to see what Iīm talhing about.

If you can help me to not to loose the connections, I would thank you very much.....

Here the original file.....

http://speedy.sh/QE2GZ/Premier-League.xlsm

When you hit the refresh button, you gonna see what happens to the team tables......

Thatīs what Iīm talking about..... The macro button, is to convert . to , (I recorded the moviments - macro).....

Thank you for your quickly reply.....

About the connection 3 (ligacao 3), youīre correct.... This connection imports the spanish league stands..... I fixed already......

About the table Goals By Half, I think only with VBA code could fix this.... But like I said, VBA code for me is like cooking (donīt know anything)....

I donīt know if itīs difficult to make this kind of code, but if you (or anyone) could help with this, I would be very appreciate. Maybe for just one team, then I could start to play to make the rest of the teams.....

It would be 1st VBA lesson .....

Besides this, thank you very much for your help.....

Hello again.....

Thank you for your help. I did the reconnections already and it workīs fine....

But I have another doubt.....

In the image below, can I import the data of the 3 arrows (Overall/Home/Away)???? Because when I select the Home tab or Away tab, the link didnīt change. So when I import the data, the only thing that appears is the Overall stats.

\1

With this table I know the % of the scored and concedeed goals by each team....

Hereīs the link page: http://www.soccerstats.com/trends.asp?league=england

The goals by halves is ok now.....

The other table with tab, I thought it would be more difficult..... When we select the Home tab or the Away tab, the link still the same. So the only data that import is the Overall tab.....

Maybe only with code.....

In this site (http://fcstats.com/statistics,portug...tugal,30,4.php) is php... The boxes wonīt show when I connect to excel....

But to put that table into a VBA code is easy??? Or itīs just difficult as the other site???

This excel file is to automate the whole process of selecting teams by criteria (Goals for, against, 1 half, 2 half, etc.).....