I'm working with Visual Basic and from a form, after entering 2 data, I need to record the same in a file.
My problem is that when I burn it in an .xls, it inserts the data in the same column:
What I need is for the first Data to go to Column A and the second to B. Also what happens to me is that I can not record the data one below the other (like a table).
Sub Grabar()
10 Rem Graba en disco en modo RANDOM
20 Open "C:\CCA\Final\prueba.xls" For Random As #1 Len = 50
30 Put #1, , regi
40 Close #1
50 MsgBox "Grabado en archivo"
End Sub
The data type is as follows and is declared at the beginning of the module
Public regi As camion
Type camion
tipo As String * 45
peso As String * 2 '
End Type