Formatting in CSV

[RobertLees]

Hi

I create a Comma Separated Value file (csv) from my VB application,
then open that file with Excel.

Excel recognises the commas, and splits the records into separate
fields as expected. Can I set properties for rows or columns or cells ?
Like bolding, or font size, etc.

Thanks
Robert

 

[Guest]

Yes.

Even though the .csv file contains no formatting information, you can always
format the cells or rows or columns manually after the file has been loaded.
You can do the same thing in VBA. For example:

Selection.Font.Bold = True

 

[Dave Peterson]

You can change the formatting after the data has been imported into excel--but
..CSV files are plain text. You won't be able to save that formatting in the
..CSV file itself.