when I am trying to save file in CVS format, comma delimiter is displaying for every field
EX: test1,test2,test3,test4
Below is the statement I am using like
workbook1.SaveAs filename.csv, 6
Please advice me how to write.
Thanks in advance
yashu
when I am trying to save file in CVS format, comma delimiter is displaying for every field
EX: test1,test2,test3,test4
Below is the statement I am using like
workbook1.SaveAs filename.csv, 6
Please advice me how to write.
Thanks in advance
yashu
Isn't that what CSV means - commas separate the values ?
What do you want it to look like?
Did you open the csv file in Notepad or in Excel?
Pete
I created CSV file from txt by using Excel VBA program.
While I am saving to CSV.. every field separated by comma
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks