Save each sheet in a workbook to separate CSV files

by

@AlexDuggleby: you don’t need to copy the worksheets, you can save them directly. e.g.:

Public Sub SaveWorksheetsAsCsv()
Dim WS As Excel.Worksheet
Dim SaveToDirectory As String

    SaveToDirectory = "C:\"

    For Each WS In ThisWorkbook.Worksheets
        WS.SaveAs SaveToDirectory & WS.Name, xlCSV
    Next

End Sub

Only potential problem is that that leaves your workbook saved as the last csv file. If you need to keep the original workbook you will need to SaveAs it.

More Related Contents:

  1. Export each sheet to a separate csv file
  2. How to color all the rows based on the cell values
  3. Using a UDF in Excel to update the worksheet
  4. How to add a reference programmatically using VBA
  5. Copy Paste Values only( xlPasteValues )
  6. automatically execute an Excel macro on a cell change
  7. VLOOKUP with multiple criteria returning values in one cell
  8. How can I concatenate strings in VBA?
  9. Copy/Paste/Calculate Visible Cells from One Column of a Filtered Table
  10. Loading addins when Excel is instantiated programmatically
  11. Excel’s fullname property with OneDrive
  12. Trying to use variables as values vba to sql
  13. How to insert an embedded picture?
  14. Copy Excel range as Picture to Outlook
  15. Obtain attribute names from XML using VBA
  16. How to determine the last Row used in VBA including blank spaces in between [duplicate]
  17. How to use FindWindow to find a visible or invisible window with a partial name in VBA
  18. How do you get a Range to return its Name?
  19. Passing variable from Form to Module in VBA
  20. How to give a time delay of less than one second in excel vba?
  21. Changing the date format to yyyy-mm-dd
  22. Delete all duplicate rows Excel vba
  23. Excel VBA: Convert a date string to a Unix timestamp
  24. excel to pdf ignores print area and calls printer
  25. Select Newest Record and Create New Table of Unique Values in Excel
  26. Excel VBA – exit for loop
  27. Are ActiveX Controls Disabled?
  28. Excel Date Conversion from yyyymmdd to mm/dd/yyyy
  29. VBA copy rows that meet criteria to another sheet
  30. VBA Dialog box to select range in different workbook

Leave a Comment