D
Dave L
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
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