Urgent help needed - exporting to csv file having format issues

I am new to vba and need some help as I can't work this out

When trying to save some specific content from one of the worksheets in an excel workbook into a CSV file,I can't get the right output format. This is critical as some columns need text qualifiers and others do not and I have to get it right as the file will go into a enterprise solution.

I have 5 columns A-E that holds data I need to export as a csv, columns A,C & E need text qualifiers, but B & D do not.

The csv file has 2 header rows, which do not have any " qualifiers

I am trying to get this to work but have 2 issues 1) Columns A,C & E need to be in quotes, with B & D not in quotes 2) The header in row 1 has extra ,,,, on the end which I want to remove

The code I am using is below, and I've attached an image of a sample file to bring it to life.

The file does the following 1) Selects a dynamic range of rows within columns A-E 2) Saves as a specific name with data & time included it it.

Please Login or Register  to view this content.

The output it gives me is:
Export file name,,,, Need to... Get rid of ",,,." on end
Column1,Column2,Column3,Column4,Column5 OK, as needed
name 1,Group1,Description 1,1,0 Need " " around Name 1, Description 1 and 0
Name 2,Group2,Description 2,1,0
name 3,Group3,Description 3,1,0
name 4,Group4,Description 4,1,0
name 5,Group5,Description 5,1,0

I need it to be:

Export file name < No " or comma's at the end
Column1,Column2,Column3,Column4,Column5 <- No "
"name 1",Group1,"Description 1",1,"0" <- " only on columns 1,3 & 5
"Name 2",Group2,"Description 2",1,"0"
"name 3",Group3,"Description 3",1,"0"
"name 4",Group4,"Description 4",1,"0"
"name 5",Group5,"Description 5",1,"0"

Original excel file looks like this: Forum_Sample.PNG

I keep looping around different solutions, so need some expert guidance please.

All suggestions welcome as getting desperate Thanks

PS the above code could be completely wrong place to start so let me know.