Urgent ! CSV double quotation problem ?

[Guest]

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

 

[NickHK]

kobeting,
Notepad merely displays the text it finds in a file. It has no concept of
..csv.
Excel attempts parsing of the structure. In this case .csv, with different
data types (number, text, etc) and splitting the data into columns on the
commas etc.

So the quick answer is you cannot.

NickHK