Dan Nielsen
New Member
- Joined
- Jan 10, 2018
- Messages
- 6
I need to export data from a excel file to a CSV file (to use for import in MailChimp) using VBA. I have dates in columns and in excel (* .xlsm) dates are correct, but after they are copied to * .CSV and I open the * CSV file again, some dates are not correct.
I have checked that all cells in the columns are in the format "date" in *.xlms but in *.CSV some is "standard" and some is "date".
Can I possibly Convert all dates into text in an easy way with a simple VBA command?
<tbody>
</tbody>
I have checked that all cells in the columns are in the format "date" in *.xlms but in *.CSV some is "standard" and some is "date".
Can I possibly Convert all dates into text in an easy way with a simple VBA command?
*.xlms | *.CSV | |||||||||||||
<colgroup><col></colgroup><tbody> </tbody> |
<colgroup><col></colgroup><tbody> </tbody> | |||||||||||||
<tbody>
</tbody>