Hello all,

I am trying to take information in an Excel file, and convert each row to a separate CSV file.

The CSV file needs this format: "title","tag1,tag2,tag3","","","author","","","","","","","Copyright","","" so there will be some blank columns.

I'd like the CSV files to be named Subject1, Subject2, Subject 3, etc. I have about 465 of them. I am using Excel 2010.

I've gotten useful information from several threads on here, but I'm not familiar with VBA enough to put them together.

Thank you!