multiple text file import in single excel sheet

[ashie.joshi]

I have many text files in a folder C:\test and I want to gather/import these files' names and data (only single-line data) into C:\test\text.xlsx in different columns with header (top row header and header can be anything).

Also, I need both the files' date and time in two separate columns in the generated Excel file.

Thanks in advance

[parttime_guy]

Get to the MS-DOS prompt or the Windows command line.
Navigate to the directory you wish to print the contents of. If you're new to the command line, familiarize yourself with the cd command and the dir command.
Once in the directory you wish to print the contents of, type one of the below commands.

dir > print.txt
or
dir > print.xls

The above command will take the list of all the files and all of the information about the files, including size, modified date, etc., and send that output to the print.txt file in the current directory.

dir /b > print.txt
or
dir /b > print.xls

This command would print only the file names and not the file information of the files in the current directory.

dir /s /b > print.txt
or
dir /s /b > print.xls

This command would print only the file names of the files in the current directory and any other files in the directories in the current directory.

Hope this helps
http://www.computerhope.com/issues/ch000772.htm

[ashie.joshi]

Hi,
Thanks for your reply,
But I need vb code for this.

[parttime_guy]

Try this

http://www.vbaexpress.com/kb/getarticle.php?kb_id=837

[mancubus]

if you are using office2007 or higher:
http://www.vbaexpress.com/kb/getarticle.php?kb_id=1042

[ashie.joshi]

Thank u so much

[ashie.joshi]

I want to add new thread pls help me