How to avoid carriage return when using #print with excel vba

Viewed 18

i wrote this code

        Print #1, "INSERT INTO utilisateur"
        Print #1, "VALUES( "
        For j = 1 To nbre_colonnes_utilisateur
            Print #1, Cells(i, j).Value & ","
        Next j
        Print #1, ");"
    Next i
    Close #1

But i want that the Print #1, Cells(i,j).Value & "," are on the same line.

Do you guys have any ideas how can i do that ?

Thanks

0 Answers
Related