Macro/Method of Importing DATA in a loop

  • Thread starter Thread starter Faraz A. Qureshi
  • Start date Start date
F

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?
 
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
 
Back
Top