PCHomepage
Programmer
This isn't so much a VBA question as it is an Excel question but maybe VBA is what's needed. I am trying to export data from Excel into CSV but it fails to enquote text fields and does not escape quotes that exist in the data. It also seems to truncate some data. For example, this LOOKS like a number even though the column is actually general text but 1.0100 exports as 1.01. Any ideas on how to get the required output? Thank you.