Saving a .CSV file

[Bezzie]

I open a .csv file from code in Excel. Find records in the .csv file and when the record was found I change a cells color to show which records were found. But then I can't save the .csv file after I'm done!

The file is opened with:

Please Login or Register  to view this content.

cFullFileName is the full path and filename of the .csv file.

I look up my records and I change the cell color. This works up to here. I can see the cells with the new colors.

But then:

Please Login or Register  to view this content.

does not save the file but does close the file. On the close it asks if I want to save the file. Selecting Save still does not save the file.

Is there some special way that a .csv file should be saved?

[TMS]

A cvs file is basically a text file. You can't colour "cells" in a text file. If that's all you are changing, you're on a loser. You'd have to save the file as an xlsx format workbook to save any formatting.

[mjr veverka]

You'd have to save the file as an xlsx format workbook to save any formatting

Also as a '.xml' file

[Bezzie]

That makes sense. Thanks.

[TMS]

You're welcome.