1
2
3

1▓
2▓
3▓
<pre><code>Wie kann ich das verhindern bzw. rausfiltern? Makro kann ich keines _
  schreiben, das diese Zeichen ersetzt, das Zeichen wird nicht erkennt. 
 
Mein Code, der das File generiert:
 
<pre><code>        Dim MyExcel As New Excel.Application
        Dim oWorkbooks As Excel.Workbooks = MyExcel.Workbooks
        Dim theWorkbook As Excel.Workbook = oWorkbooks.Add
        Dim oSheet As Excel.Worksheet
        Dim xlsPath As String = "C:\test\file2.xls"
 
        theWorkbook = oWorkbooks.Open(xlsPath)
        oSheet = MyExcel.ActiveSheet()
        oSheet.Cells(5, 7) = txtComment.Text
 
        MyExcel.Quit()
 
        Marshal.ReleaseComObject(oSheet)
        Marshal.ReleaseComObject(oWorkbooks)
        Marshal.ReleaseComObject(theWorkbook)
        Marshal.ReleaseComObject(MyExcel)
 
        GC.Collect()
        GC.WaitForPendingFinalizers()
 
        '  Finally
        oSheet = Nothing
        theWorkbook = Nothing
        oWorkbooks = Nothing
        MyExcel = Nothing

Liebe Gr?sse,
Simon