Web query VBA

[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.
Therefore, it should create a VBA.



I'll explain with pictures.

----------------------------------------------------------------
1. Target webpage.


aion.plaync.co.kr/live/vendor/searchDetail?serverID=2&race=0&name=%EC%98%A4%EB%93%
9C&page=1&category=&quality=31&from=1&to=110&exact=0&sort=rank%2Clevel-dec%2Cquality-
dec&itemNameID=47814103f369dc69070359a33ea5d0ea_07



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

lyra.co.kr/Image2.jpg

From 'Target webpage' to 'Target table' is not constant, the time is displayed.
(Show up immediately or delayed 5~8 seconds)

And... 'Target table' long wait, sometimes does not appear.
So... When that happens, must make 5 times to retry.
5 retries fail to exit the script.





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

lyra.co.kr/Image4.jpg


In Step 2, if it succeeds in extracting 'Target table' to 'Excel file' is stored.

----------------------------------------------------------------



This will create a VBA script.
Please help.

[arang]

- 'Target webpage' HTMLsource -
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.

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

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

[Aussiebear]

Given that you have cross posted this issue on a number of other forums, you might well find that others will wait until another forum offers you a suggestion.

[arang]

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



thecodecage.com/forumz/members-excel-vba-programming/208183-web-query-excel-visual-basic-applications.html#post742071