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.
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.