AW: Aus dem Archiv
17.11.2022 09:16:02
Thomas
Hallo Ralf,
danke für den Tip, der Code von Nepumuk
Option Explicit
Sub CSV_mit_Anfuehrungszeichen()
Dim wks As Worksheet, Ze As Long, Sp As Long, ZeTmp As String
Dim lCol As Long, lRow As Long, Frf As Long
Dim Anf As String, csvExport As String
Const Trenner As String = "," 'Trenner für Spalten, kann angepasst werden
Anf = Chr$(34)
csvExport = "H:\csvExportSpezial" & Format$(Now, "yyyy.mm.dd_Hh-Nn-Ss") & ".csv"
Frf = FreeFile
Set wks = ThisWorkbook.Worksheets("Tabelle1") 'Anpassen: Register-Name
lCol = wks.Cells(1, Columns.Count).End(xlToLeft).Column
lRow = wks.Cells(Rows.Count, 1).End(xlUp).Row
Open csvExport For Output As #Frf
For Ze = 1 To lRow
For Sp = 1 To lCol
ZeTmp = ZeTmp & Trenner & Anf & CStr(wks.Cells(Ze, Sp).Text) & Anf
Next Sp
ZeTmp = Mid(ZeTmp, 2) 'Letztes Trennzeichen löschen
Print #Frf, ZeTmp
ZeTmp = ""
Next Ze
Close #Frf
End Sub
funktioniert hervorragend!
Vielen Dank