Macro/Method of Importing DATA in a loop

[Faraz A. Qureshi]

I have received around 280 text files with delimiters to be imported in a
single excel file.

Any idea, How to start the exercise in a looping manner or together ,
instead of opening each and every separately?

 

[Jacob Skaria]

If all text files are of the same format (field structure); from command mode
copy the files into a single file. For example if you have your files placed
in c:\temp\

From command line use the copy command to merge the files to a single
file...and then open the merged.txt in excel...

c:\temp\copy *.txt c:\merged.txt/b


If this post helps click Yes

 

[Faraz A. Qureshi]

MY GOD!!!!!

You might think it to be overstated. BUT!!!! U R the best!