Excel 2007 - saving as a .csv no longer encases the fields in inverted commas
Posted on 2011-03-07
I appreciate that this question has already been posed - see "Export to CSV options in Excel 2007", but I am looking for a better solution.
In earlier versions of Excel (before 2007) when you Saved As a .csv file the fields would be encased in inverted commas, e.g. "123","ABC","XYZ" But now I get 123,ABC,XYZ
I need the inverted commas because the .csv file is imported into a Visual Basic program. I don't want to make the import procedure any more complicated for my users, so adding Access to the mix isn't really an option. Without reverting to Excel 2003, does anyone know of a workaround for this problem?