Export sheet as CSV with comma delimiter and double quote (") as indicator

[Marco-Kun]

Hello everyone,

The title explains it all. I would like to export a sheet which looks like the one below to a CSV which looks like the one at the bottom of this post.

Thanks in advance.

Kind regards,

Marco

Please Login or Register  to view this content.

Please Login or Register  to view this content.

[watersev]

hi Marco, option, please check if it's what you are after. Save xlsm file and press Run button or run code "test"

[Marco-Kun]

Hi watersev.

Thank you for the reply! The output looks great!
However, I tried to implement this on my workbook now, but my data starts on A2.

So I tried to change the code to:

Please Login or Register  to view this content.

With this I receive an error on:

Please Login or Register  to view this content.

After this I tried changing the code to:

Please Login or Register  to view this content.

With this, the CSV file is created, but on the bottom is an extra line with:

Please Login or Register  to view this content.

How can I fix this?

Thanks in advance!

Kind regards,

Marco

[watersev]

1st change:

Please Login or Register  to view this content.

2nd change:

Please Login or Register  to view this content.

[watersev]

if that errors out as well or result is not as expected post your file with data

[Marco-Kun]

Thank you for the reply. I'm not sure if I did correctly, it still gives an error.

I added an example of my data.

Kind regards,

Marco

[watersev]

what is expected result in the result file if the cell contains calculation error - M7,M13?

[Marco-Kun]

These cells don't have a calculation error for me as this code solves that for me in ThisWorkBook.
31.30 and -32.95 are the results though, respectively.

Please Login or Register  to view this content.

[watersev]

try this:

Please Login or Register  to view this content.