williamkscheung
New Member
Hi everyone,
Referring to my replied post last Monday (http://forum.chandoo.org/threads/macros-web-query-huge-headache-can-anyone-help-me.4175/#post-150230), I would like to seek for the forum expert’s help in using vba code to generate the web queries for a list of links on a spreadsheet.
More specifically, my task is:
I have a list of web pages’ links on the spreadsheet 1 (vide the attachment), and I would like to import the “xlEntirepage” of each link in a separate-newly inserted spreadsheet. (i.e. 1st link to the "Sheet2"; 2nd link to the "Sheet3" etc.)
I put my utmost effort and tried to revise the vba code provided by other vba expert @SirJB7 yet failed to achieve my task. Attached please find my file for your perusal. Your help is indeed greatly appreciated.
Many many thanks!!
P.S. As my first post is directed to @SirJB7, I have to apologize to bring up my question as a new thread here after several days of my initial post; since it is quite an urgent task to be completed within this month. I wish to try if any experts here can help.
Will
Referring to my replied post last Monday (http://forum.chandoo.org/threads/macros-web-query-huge-headache-can-anyone-help-me.4175/#post-150230), I would like to seek for the forum expert’s help in using vba code to generate the web queries for a list of links on a spreadsheet.
More specifically, my task is:
I have a list of web pages’ links on the spreadsheet 1 (vide the attachment), and I would like to import the “xlEntirepage” of each link in a separate-newly inserted spreadsheet. (i.e. 1st link to the "Sheet2"; 2nd link to the "Sheet3" etc.)
I put my utmost effort and tried to revise the vba code provided by other vba expert @SirJB7 yet failed to achieve my task. Attached please find my file for your perusal. Your help is indeed greatly appreciated.
Many many thanks!!
P.S. As my first post is directed to @SirJB7, I have to apologize to bring up my question as a new thread here after several days of my initial post; since it is quite an urgent task to be completed within this month. I wish to try if any experts here can help.
Will