Forum Discussion
JonAstolfi
Sep 02, 2021Copper Contributor
MS Excel Export CSV to Unique File
Is there a way to export from a multi-tabbed Excel workbook to a unique CSV file? Currently I am https://support.microsoft.com/en-us/office/import-or-export-text-txt-or-csv-files-5250ac4c-663c-47ce-...
JonAstolfi
Sep 02, 2021Copper Contributor
Hello DKoontz
The concern is not in relation to a change in the existing underlying data, but rather it changes the file type that affects continuing with new data/effort.
I'm seeking to find something better than the "clunky" process you've identified.
Have you created anything in VBA for this?
DKoontz
Sep 02, 2021Iron Contributor
Saving as CVS then saving back to XLSX isn't too bad, but for VBA you would just need a macro that saved as CSV the saved back to XLSX.
Something like this should work: just change where your workbook and export should go:
ActiveWorkbook. SaveAs FileName:="C:\My Documents\MyCSV", FileFormat:=xlCSV
ActiveWorkbook. SaveAs FileName:="C:\My Documents\MyXLXS", FileFormat:=xlOpenXMLWorkbook