Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I have an Excel file that i run a marco against and it will save it as a csv
type file (with a different extension). The problem is that some of my cells have commas in them. When i open the saved file in Notepad, Excel has put double quotes around any cell values that have commas in them. Other than the quotes the notepad file looks perfect. Is there a way to get those out of there? Her is the part of my code that saves the file if that helps any. ActiveWorkbook.SaveAs Filename:= _ "C:\Documents and Settings\dlefler\Desktop\" & PoId & ".otto", FileFormat:=xlTextMSDOS, _ CreateBackup:=False |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Double quotes when exporting to tab delimited file | Excel Discussion (Misc queries) | |||
change straight quotes to curly quotes | Excel Discussion (Misc queries) | |||
Why Saving a file to a CSV, Excel does not put text into Quotes? | Excel Discussion (Misc queries) | |||
CSV File with double quotes | Excel Programming | |||
why are there quotes in my exported text file? | Excel Discussion (Misc queries) |