How to save semi-colon delimited csv file using VBA?

by

i’ve just checked this because had same problem. Filename has no functionality in this case.

This is what worked for me:

With ActiveWorkbook
    .SaveAs Filename:="My File.csv", FileFormat:=xlCSV, Local:=True
    .Close False
End With

In regional settings -> ; <- as list separator. It is also important not to save changes when closing -> with Close you have to use False.

More Related Contents:

  1. How do you change the value of a cell in excel by clicking on it using VBA? [closed]
  2. Excel Number Separation [closed]
  3. excel vba compare & copy worksheets from 2 excel files
  4. VBA Stuck after certain loop
  5. How do I use FileSystemObject in VBA?
  6. Is the . in .Range necessary when defined by .Cells?
  7. How to return a result from a VBA function
  8. Cycle through sub-folders and files in a user-specified root directory [duplicate]
  9. Convert Text to Date?
  10. Run Excel Macro from Outside Excel Using VBScript From Command Line
  11. Importing text file into excel sheet
  12. Filling any empty cells with the value above
  13. Properly Handling Errors in VBA (Excel)
  14. Password hash function for Excel VBA
  15. Is there a way to slow down a Web Scraper so it will pick up the code?
  16. Aggregate, Collate and Transpose rows into columns
  17. VBA Excel sort range by specific column
  18. Select method of Range class failed via VBA
  19. Delete cells in an Excel column when rows = 0
  20. Is there a way to import data from .csv to active excel sheet?
  21. Comparison of Dictionary, Collections and Arrays
  22. How to add events to dynamically created controls (buttons, listboxes) in Excel VBA userform
  23. How to copy data from closed workbooks (keeping them closed) into master workbook using VBA?
  24. How do I reference tables in Excel using VBA?
  25. Error 1004 when setting Range.Locked
  26. How to extract groups of numbers from a string in vba
  27. Get existing IE via VBA
  28. excel vba how to copy the value of multiple non-contiguous ranges into an array
  29. using a sheet in an excel user defined function
  30. Excel VBA For Each Worksheet Loop

Leave a Comment