Export Each Excel Row as Separate Files with Header Row

Ladies and Gentlemen, I'm stumped and would appreciate your expertise. I have researched this here and elsewhere, but the answer eludes me.
Summary: I just want to export each row of an Excel file to a new file, but I must have the same header row for each file. Also, some cells are blank, but they still must be included.
Details:
Excel Worksheet with 13 Columns (A-M) and 11 Rows (1-11)
Row 1 is the header row which must be included in each file
Contents of each row must be exported to a new file
Column A for each row is used for the name of the new file
If any Cells are blank, EXCEPT Column 1, they still must be included in the new file.
Script should continue until a blank value in Column A
I need to be able to code the directory for the output.
I will attach what I have so far - not elegant, it works, but does not give me what I need.
It only takes the individual row with no header and exports to the directory where the workbook is open.

Please Login or Register  to view this content.

---

Worksheet.jpg

It looks like you want to save each row plus header as a comma-delimited file using the filename in column A?

Ok, then this macro created the attached AU files.

Please Login or Register  to view this content.

Ok, there is no inherent comma+quotes delimited CSV format, so we have to fake it. This is two functions now.

Please Login or Register  to view this content.