Appending a second csv file
 

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?

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

"Rick" wrote in message
...
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?

You are correct, it is the total amount.

"HansM" wrote:

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

"Rick" wrote in message
...
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?

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

Thank you,

Rick

"HansM" wrote:

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

"Rick" wrote in message
...
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?