Export Data (as CSV) with formatting and Comments

Question

Is there a way to Export my Data in Excel with VBA whilst also exporting Cellcomments and ColorFormatting?

I don't quite find a solution to export it that way.

Answer 1

According to Wikipedia:

In computing, a comma-separated values (CSV) file stores tabular data (numbers and text) in plain text.

Thus no colors and no comments.

If you want to store them in CSV, you can write code to collect these information from cells and store them as text somewhere in the worksheet (e.g. copy color as hex code).