Importing TEXT file from web

[Murtaza]

I have setup a list in MS Excel file as below

Column B
http://www.somewebsite.com/text1.txt
http://www.somewebsite.com/text2.txt
http://www.somewebsite.com/text3.txt

Now, I would like to import all the files in Excel. I tried the 'Import Text
File' option but its kind of repetative task and requires user inputs.

Can I do it through macro? like a Macro import the files in single excel
sheet


Thank you,
Murtaza

 

[Murtaza]

I have setup a list in MS Excel sheet as below:

in Column B
1 http://www.somewebsite.com/text1.txt
2 http://www.somewebsite.com/text2.txt
3 http://www.somewebsite.com/text3.txt

Now, I would like to import all the txt files in Excel either on seperate
sheets or single sheet. I tried the 'Import Text
File' option but its kind of repetative task and requires user inputs.

Can I do it through macro?

Thank you,
Murtaza