Dear All,

I need to write a Marco to export some data from an excel file to a new
CSV file. Some data with double quotation mark will export to CSV file.

For example, I need to export a column name with "ABC", my code is

sheet1.cells(1,4).value = """ABC"""
.......
oWorkbook.save

If I open the CSV file by using Excel, the cell display "ABC", so it is
correct. But when I use notepad to open the CSV file. It displays """ABC""",
it is not my target format.

I would like to ask how can I change my code to display "ABC" (both Excel
and Notepad).

Thanks