I will look at thsi tonight. To run the code you need to use VBA
(Visual Basic) programming language that is part of Excel. If you open
Excel and right click the tab (normally says sheet1) at the bottom of
the worksheet and select "View Code". the from the VBA menu add a
module using the menu Insert - Mode. then you cna paste the code from
the posting into the module and run the code. the code won't run
properly because the columns in your CSV file is different from the code
you posted. The changes are minor.

The Code opens CSV files and puts them into an Excel XLS workbook. So
yo uwould save the results asa a workbook even thought your files were
originally CSV files. I could save tthe results either as a CSV file or
leavve them in a XLS workbook.


--
joel
------------------------------------------------------------------------
joel's Profile: 229
View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=180054

http://www.thecodecage.com/forumz/chat.php