Please help me turn this web data import code into a loop

[efarnham]

Hi - You guys helped me out before and I'm hoping someone can give me a little advice with this problem. Here's code to import data from three url's, results of a search query in a web database. This is no big deal with 3 url's, contained in cells A1,B1,C1. Problem is I have searches that have over 8000 url's so I need to convert this to a loop. I'm not sure if it's best to use a For/next or an If then (like If activecell <> "" as it tabs across the list). With either method, I really need help creating and stepping the variables needed to keep pasting the imported data straight down the page. I would most greatly appreciate any help you guys can offer. Thanks!

Please Login or Register  to view this content.

[venkat1926]

see attached file
EFARNHAM data import loop (1).xlsm

the macro is "test" in the module
IT TAKES NEARLY 30 SECONDS TO LOOP OVER THE THREE URLS IN a1 TO c1

the macro is also given below
take care that the urls are in row no.1 from A1 to right.

Please Login or Register  to view this content.