Save as .CSV - Speech marks / extra comma issues

[wahbob]

Hi All,

Hoping someone might have a quick solution to the following:

I have a vba script that is saving a worksheet as a .csv file

'CSV_Create is name of worksheet in master file I'm wanting to covert to .csv

CSV_Create.Copy
ActiveWorkbook.SaveAs Filename:=FullName, FileFormat:=xlCSV, CreateBackup:=True
ActiveWorkbook.Close

This correctly saves the .csv file, but depending on how I structure the data before .csv converting, I come across one of 2 errors in the output format compared to what I want.

Option 1
I have the data as a single text string, separated by commas in Column A.
When re-opening as a .csv in notepad, this shows the correct information, but with speech marks around the string.

i.e.

"a,b,c,d" rather than a,b,c,d

If I use this method, I need a way of removing the speech marks.

Option 2
I separate each bit of text into a column, however the final row of my data always has data in one extra column (an asterisk) to signify its the final line.
This cannot be removed as the .csv file requires this to be processed correctly.

Because of this, I get an additional, unwanted comma at the end of each row until the final line, highlighted in red below.

i.e.

a,b,c,d,
e,f,g,h,
i,j,k,l,*

Any ideas how I can get the desired output:

i.e.

a,b,c,d
e,f,g,h
i,j,k,l,*

Thanks

Rob