PDA

View Full Version : HELP!!! Need a VBA code to get a table from a site



betdti
06-11-2016, 05:09 AM
HELP!!! Need a VBA code to get a table from this site ............................ i want a code because i need to get into excel all the countries in different sheets. the code i supose i can modify by myself after for another country. i dont want to use copy/paste because there is a lot of countries and this take time.

betdti
06-11-2016, 05:11 AM
the site i can't post it.....

betdti
06-11-2016, 05:11 AM
up

betdti
06-11-2016, 05:13 AM
next post i can show you the site.

betdti
06-11-2016, 05:16 AM
offf i can't.....

mdmackillop
06-11-2016, 05:17 AM
Please do not enter meaningless posts to boost your count. Explain your issue. Can you use Go Advanced/Manage Attachments to post a sample workbook?

betdti
06-11-2016, 05:34 AM
i very new with VBA. i don't have a sample. The website is very simple but with web query funtion is not working. the website i supose is in java or something......

snb
06-11-2016, 08:08 AM
If you don't have a sample I don't have an answer.
Start with: Excel VBA Programming For Dummies by John Walkenbach | 9781119077398 | Paperback | Barnes & Noble (http://www.barnesandnoble.com/w/excel-vba-programming-for-dummies-john-walkenbach/1101874584)

betdti
06-12-2016, 01:35 AM
simplesoccerstats.com/stats/teamstats.php?lge=0&type=corners&season=0

betdti
06-12-2016, 01:38 AM
this is the site. please help. i need a vba code to insert that table in excel.