Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Urgent ! CSV double quotation problem ?
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Urgent ! CSV double quotation problem ?
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 "kobeting" wrote in message ... 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
CELL return value without double quotation marks | Excel Worksheet Functions | |||
Excel CSV file: How to preserve double quotation mark on Unix ftp? | Excel Discussion (Misc queries) | |||
double quotation marked | Excel Discussion (Misc queries) | |||
Single or Double Quotation Mark and it comes up twice | Setting up and Configuration of Excel | |||
How to include a double quotation character in a string? | Excel Programming |