Macro/Method of Importing DATA in a loop
 

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?
--
Best Regards,

Faraz

Macro/Method of Importing DATA in a loop
 

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
---------------
Jacob Skaria


"Faraz A. Qureshi" wrote:

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?
--
Best Regards,

Faraz

Macro/Method of Importing DATA in a loop
 

MY GOD!!!!!

You might think it to be overstated. BUT!!!! U R the best!
--
Best Regards,

Faraz


"Jacob Skaria" wrote:

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
---------------
Jacob Skaria


"Faraz A. Qureshi" wrote:

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?
--
Best Regards,

Faraz