| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Paste method error in macro | Excel Discussion (Misc queries) | |||
| Importing data via macro | New Users to Excel | |||
| Importing Data - Macro or Script | Excel Worksheet Functions | |||
| importing data using a macro | Excel Discussion (Misc queries) | |||
| Easiest Way to do this Importing method? | Excel Worksheet Functions | |||
Linear Mode
