Web query VBA Problem

[arang]

Hi

I can not speak English.
So, I use a translator.
My country, this issue could be resolved.
So here is the question.

My problem is the 'Web query'.
'Excel Basic Web query Maker' was not possible.
So, 'VBA' must make.



I'll explain with pictures.



1. Target webpage.

http://aion.plaync.co.kr/live/vendo...temNameID=47814103f369dc69070359a33ea5d0ea_07




2. Gets the 'Target table' on the webpage.

'Target webpage' connected to 'Target table' appears after 7~8 seconds.

And 'Target web page' is unstable.
So sometimes does not get a table.
When that happens, must make 5 times to retry.
5 retries fail to exit the script.





3. Save 'table' to 'Excel file' is extracted.

This will create a VBA script.

 

[arang]

notice

- 'Target webpage' HTMLsource -
http://lyra.co.kr/HTMLsource.ZIP
In HTML source, you can not find the target table.
This is probably because the table is implemented by JAVA.
(HTML can not be seen in the target table.)


*************************************************
****************** Cross-posts ******************
*************************************************
I've posted the same question somewhere else.
I have my iPhone with all the posts will be checked in real time.
If this resolves the problem of all posts will be deleted immediately.
If you see yourself will not solve the problem yet.

http://www.mrexcel.com/forum/showthread.php?t=511399
http://www.excelforum.com/excel-programming/754528-web-query-vba-problem.html#post2424469
http://www.vbaexpress.com/forum/showthread.php?t=35138
http://chandoo.org/forums/topic/web-query-vba
http://www.xtremevbtalk.com/showthread.php?p=1374566#post1374566
http://www.thecodecage.com/forumz/members-excel-vba-programming/208183-web-query-excel-visual-basic-
applications.html#post742071
http://www.techsupportforum.com/mic...t/531284-web-query-excel-vba.html#post3001385
http://www.vbforums.com/forumdisplay.php?f=37

*************************************************

 

[arang]

I solved this problem in other forums.
Thank you for trying.



http://www.thecodecage.com/forumz/m...cel-visual-basic-applications.html#post742071