程序如下:
Private Sub Command1_Click()
Timer2.Interval = Val(Text9.Text * 1000)
If Timer2.Enabled = False Then
Timer2.Enabled = True
End If
If Val(Text9.Text) = 0 Then
choice = MsgBox("未设置时间间隔!", vbYes + vbExclamation + vbDefaultButton1, "")
Exit Sub
End If
n = mysheet.UsedRange.Rows.Count
For n = 2 To n + 1
mysheet.Cells(1, 1).Value = "1#采集点"
mysheet.Cells(1, 2).Value = "2#采集点"
mysheet.Cells(1, 3).Value = "3#采集点"
mysheet.Cells(1, 4).Value = "4#采集点"
mysheet.Cells(1, 5).Value = "5#采集点"
mysheet.Cells(1, 6).Value = "6#采集点"
mysheet.Cells(1, 7).Value = "7#采集点"
mysheet.Cells(1, 8).Value = "8#采集点"
mysheet.Cells(1, 9).Value = "数据采集时间"
mysheet.Cells(n, 1).Value = Text1.Text
mysheet.Cells(n, 2).Value = Text2.Text
mysheet.Cells(n, 3).Value = Text3.Text
mysheet.Cells(n, 4).Value = Text4.Text
mysheet.Cells(n, 5).Value = Text5.Text
mysheet.Cells(n, 6).Value = Text6.Text
mysheet.Cells(n, 7).Value = Text7.Text
mysheet.Cells(n, 8).Value = Text8.Text
mysheet.Cells(n, 9).Value = Text11.Text
mybook.Save
Next n
End Sub