I have an Excel workbook set up with a macro that extracts information from 3 worksheets and creates 3 .csv files containing the information in the same format in the same separate columns. The 3 .csv are located in one folder. I want to combine the data of all three files and create one .csv file. One of the files has a header record and the one of the files has a trailer record. I want the macro to combine in sequence so that I end up with one file that has a header, detail and a trailer.
Can I do this?