Hi all!
I'm new to the forum, and I'm trying to do a web query to import data from a web page. I'm on Excel 2010. This is the web page:
Australia Box Office, September 5–8, 2013
I tried to do it through the Data > From Web> New Web Query method and selected the table but it returns the error message:
"The Web query returned no data. To change the query, click ok"
I'm thinking that the code on the page is somehow not compatible with a web query direct import. Is there a way I might be able to enter a macro in VBA to import the data?
I'm new to the forum, and I'm trying to do a web query to import data from a web page. I'm on Excel 2010. This is the web page:
Australia Box Office, September 5–8, 2013
I tried to do it through the Data > From Web> New Web Query method and selected the table but it returns the error message:
"The Web query returned no data. To change the query, click ok"
I'm thinking that the code on the page is somehow not compatible with a web query direct import. Is there a way I might be able to enter a macro in VBA to import the data?
