Dumping multiple text files into Excel file

June 14, 2011 at 14:20:12
Specs: Windows XP
Hi, thanks for help in advance...
I have a folder with hundreds of text files that get generated every day with the following format

-----user.txt------
Field1, Field2, Field3, Field4, Field5

I want to dump every file into an excel file with formatting(Headers for each column, with styles)
I can dump the files without formatting using a batch file no problem, but with formatting i havent tried before with VB. I can create the excel object, but can someone help me with the syntax to create the headers, and styles(if possible)
and also should i save excel file as xls or csv?
to look like this:
--------excel file---------

Field1 Field2 Field3 Field4 Field5
-------- --------- -------- -------- --------

<data> <data> <data> <data> <data>


See More: Dumping multiple text files into Excel file

Report •


#1
June 14, 2011 at 18:43:23
-Sorry. Inappropriate response.-
- Wrong forum -

Report •
Related Solutions


Ask Question