Help - Need macro to create a CSV file from a worksheet with different formatting

[jstevanus]

Help - Need macro to create a CSV file from a worksheet with different formatting

I've done a little C++, but am new to VBA.* Users need a button (or other easy method) that will copy rows from their worksheet into a new CSV file with a few changes.* The number of rows can vary, as well as the filename.* And is there an easy way for users to get this functionality?* I've attached an example of the original file and what the new CSV should look like (had to upload CSV as Excel).

Table 1 (original workbook is Excel 2003)

Project Number ERP Ref No. Project Name
B004 5555 BB Jackson Project
B005 abc123 BB Date Demo Project


Table 2* (new CSV):* Some notes at the top, then a "D" in the first new column, and then "Standard" in the next new column for each record)*

~~Notes for user in top few rows.
~~~Notes for user in top few rows.
~Notes for user in top few rows.

D Tab Name Project Number ERP Reference Number Project Name

D Standard B004 5555 Jackson Project
D Standard B005 abc123 Date Demo Project

[dflak]

Try this. It will create a CSV file in the same directory as the program with the same name as the program.