i = 0 For r = 0 To 9 For i = 0 To 9 DataArray(r) = Tableau(i) i = i + 1 Next i Next r
Vous n’avez pas trouvé la réponse que vous recherchez ?
Posez votre questionDataArray(r) = Tableau(i)
Set oSheet = oBook.Worksheets(1)
oBook.SaveAs "C:\Book7.xls"
Private Sub Command1_Click() Dim Tableau(33) As String Dim oExcel As Object Dim oBook As Object Dim oSheet As Object MSComm1.CommPort = 5 MSComm1.Settings = "115200,O,8,1" MSComm1.InputLen = 0 MSComm1.PortOpen = True Frame1 = "Connection établie" MSComm1.Output = "%01#RDD0000000033**" & Chr(13) MsgBox "" a = MSComm1.Input Label2 = a Tableau(0) = Mid$(a, 7, 4) Tableau(1) = Mid$(a, 11, 4) Tableau(3) = Mid$(a, 15, 4) Tableau(4) = Mid$(a, 19, 4) Tableau(5) = Mid$(a, 23, 4) Tableau(6) = Mid$(a, 27, 4) Tableau(7) = Mid$(a, 31, 4) Tableau(8) = Mid$(a, 35, 4) Tableau(9) = Mid$(a, 39, 4) Set oExcel = CreateObject("Excel.Application") Set oBook = oExcel.Workbooks.Add Dim DataArray(1 To 10) As String Dim r As Integer Dim i As Integer i = 0 For r = 0 To 9 For i = 0 To 9 DataArray(r) = Tableau(i) i = i + 1 Next i Next r Set oSheet = oBook.Worksheets(1) oSheet.Range("A1:C1").Value = Array("Nombre Passage") oSheet.Range("A2").Resize(34, 1).Value = DataArray oExcel.Visible = True MSComm1.PortOpen = False
Set oExcel = CreateObject("Excel.Application") Set oBook = oExcel.Workbooks.Add Dim DataArray(0 To 9) As String Dim r As Integer Dim i As Integer i = 0 For r = 0 To 9 DataArray(r) = Tableau(i) i = i + 1 Next r Set oSheet = oBook.Worksheets(1) oSheet.Range("A1").Value = Array("Nombre Passage") oSheet.Range("A2").Resize(10, 1).Value = DataArray oExcel.Visible = True MSComm1.PortOpen = False