Thread: Importing TEXT file from web
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.links,microsoft.public.excel.misc,microsoft.public.excel.programming
Murtaza Murtaza is offline
external usenet poster
  
Posts: 12
Default Importing TXT file from web
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


Reply With QuoteReply With Quote