arang
11-25-2010, 04:02 AM
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.
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.