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

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 •

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

Report •
Related Solutions

Ask Question