Appending a second csv file

[Guest]

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?

 

[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?

 

[Guest]

You are correct, it is the total amount.

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?

 

[Guest]

You are correct. It is a total amount as well as other information.

Thank you,

Rick