Appending a second csv file

R

Rick

I have been working with importing a csv file into excel and then saving the
output as a prn file that we will use for uploading.

My next challenge is to append at the end of this Excel file (before saving
as a prn) with a second file that will have different fixed length
requirements than the original import. The second file will consist of a
single row but again the fixed length requirements are different than the
original import.

Any ideas how to automate this or since it is a single row should we just
input manually? Any advice?
 
H

HansM

Record it once as a macro, put a button on the toolbar and click it when
ready to execute the macro. I take it that this is some form of
footer/trailer record that you may have to edit?
 
R

Rick

You are correct, it is the total amount.

HansM said:
Record it once as a macro, put a button on the toolbar and click it when
ready to execute the macro. I take it that this is some form of
footer/trailer record that you may have to edit?
Click to expand...
 
Top