Hi , I am from Malaysia, I have an excel vba question : how to retrieve table data from web by excel VBA?
Let said I want to copy a table and paste it into excel , the table is from http://www.nowgoal.com/detail/561532.html , i just want the data , similar to copy contents from web & paste it into excel as unicode text , no need the data to link to excel like web query , also no need the web formatting.
But the problem is if I paste it as unicode text , the “Kick-off“ and “First Yellow Card “ sign “+“ will remove in excel , because it is a image, and if paste it as web formatting , will need to wait for long time for loading , plus I want to retrieve a few thounsand of this kind of table , so manually copy the table one by one from web pages and paste it into excel is tedious.
I have tried excel web query and record it as a macro , but the problem is its speed is very slow and always make excel crash.
Your help is much more appreciate , thanks!
Let said I want to copy a table and paste it into excel , the table is from http://www.nowgoal.com/detail/561532.html , i just want the data , similar to copy contents from web & paste it into excel as unicode text , no need the data to link to excel like web query , also no need the web formatting.
But the problem is if I paste it as unicode text , the “Kick-off“ and “First Yellow Card “ sign “+“ will remove in excel , because it is a image, and if paste it as web formatting , will need to wait for long time for loading , plus I want to retrieve a few thounsand of this kind of table , so manually copy the table one by one from web pages and paste it into excel is tedious.
I have tried excel web query and record it as a macro , but the problem is its speed is very slow and always make excel crash.
Your help is much more appreciate , thanks!
