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
|