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.

So, 'VBA' must make.


I'll explain with pictures.


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


1. Target webpage.


http://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'.


http://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.


http://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 -


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://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/microsoft-support/microsoft-office-support/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/members-excel-vba-programming/208183-web-query-excel-visual-basic-applications.html#post742071