Marcel_Go

the sequence of char 10 and 13 isn't correct, this solve it [CODE] mytext= Replace(mytext, Chr(13) & Chr(10), Chr(255)) ' this is ok, so save it mytext= Replace(mytext, Chr(10), Chr(13) & Chr(10)) 'change the 10-code mytext= Replace(mytext, Chr(255), Chr(13) & Chr(10)) ' and set the ok's back[/CODE]

What code did you use ?

why not using the datagridview.UserDeletingRow? e.row.index gives the row one did ask to delete.

change the quotes you need in the sheet by chr(34) and use only the quotes where you need them in your program. If you need "this is an example" (with the quotes) in excel you have to script : chr(34) & "this is an example" & chr(34).

in the click event : grid.item(colomnname,grid.CurrentRow.index).value gives the value from the 'columname' - row-cell

textbox1.font=new font("verdana",10,fontstyle.bold) textbox1.font=new font("verdana",10,fontstyle.regular)

did you use a .SuspendLayout() and in the same scope a .ResumeLayout() ?

Hi Steve, You know, I had the same problem and after a lot of debugging I found the ExecuteNonQuery took only 0.2 seconds, but the .Connection.Close() took over a second. I marked that line as comment and the program is running fast as lightning. I'm not sure it's a good …