xlbook.DisplayAlerts = False xlbook.Save xlbook.Close xlapp.Quit Set xlbook = Nothing Set xlapp= Nothing
xlapp.DisplayAlerts = False '不提示保存
菜单:工程->引用->Microsoft Excel...Private Sub Command1_Click() Dim xlapp As Excel.Application Dim xlbook As Excel.Workbook Dim xlsheet As Excel.Worksheet xlapp.Visible = False Set xlbook = xlapp.Workbooks.Open("D:\temp\bb.xls") Set xlsheet = xlbook.Worksheets(1)
Static i As Integer For i = 1 To i xlsheet.Cells(i + 1, 1) = Val(Text1.Text) '将text赋给第一列第一行 以后每次行加一 xlsheet.Cells(i + 1, 2) = Val(Text2.Text) '将text赋给第二列第一行 以后每次行加一 Next i
xlbook.DisplayAlerts = False xlbook.Save xlbook.Close xlapp.Quit Set xlbook = Nothing Set xlapp= Nothing
Private Sub Command1_Click() Dim xlapp As New Excel.Application Dim xlbook As New Excel.Workbook Dim xlsheet As New Excel.Worksheet
xlapp.Visible = False Set xlbook = xlapp.Workbooks.Open("D:\temp\bb.xls") Set xlsheet = xlbook.Worksheets(1)
Static i As Integer For i = 1 To i xlsheet.Cells(i + 1, 1) = Val(Text1.Text) '将text赋给第一列第一行 以后每次行加一 xlsheet.Cells(i + 1, 2) = Val(Text2.Text) '将text赋给第二列第一行 以后每次行加一 Next i
xlbook.DisplayAlerts = False xlbook.Save xlbook.Close xlapp.Quit Set xlbook = Nothing Set xlapp = Nothing End Sub
xlbook.DisplayAlerts = False
xlbook.Save
xlbook.Close
xlapp.Quit
Set xlbook = Nothing
Set xlapp= Nothing
Dim xlapp As Excel.Application
Dim xlbook As Excel.Workbook
Dim xlsheet As Excel.Worksheet xlapp.Visible = False
Set xlbook = xlapp.Workbooks.Open("D:\temp\bb.xls")
Set xlsheet = xlbook.Worksheets(1)
Static i As Integer
For i = 1 To i
xlsheet.Cells(i + 1, 1) = Val(Text1.Text) '将text赋给第一列第一行 以后每次行加一
xlsheet.Cells(i + 1, 2) = Val(Text2.Text) '将text赋给第二列第一行 以后每次行加一
Next i
xlbook.DisplayAlerts = False
xlbook.Save
xlbook.Close
xlapp.Quit
Set xlbook = Nothing
Set xlapp= Nothing
Dim xlapp As New Excel.Application
Dim xlbook As New Excel.Workbook
Dim xlsheet As New Excel.Worksheet
xlapp.Visible = False
Set xlbook = xlapp.Workbooks.Open("D:\temp\bb.xls")
Set xlsheet = xlbook.Worksheets(1)
Static i As Integer
For i = 1 To i
xlsheet.Cells(i + 1, 1) = Val(Text1.Text) '将text赋给第一列第一行 以后每次行加一
xlsheet.Cells(i + 1, 2) = Val(Text2.Text) '将text赋给第二列第一行 以后每次行加一
Next i
xlbook.DisplayAlerts = False
xlbook.Save
xlbook.Close
xlapp.Quit
Set xlbook = Nothing
Set xlapp = Nothing
End Sub
这句改用xlbook.saveas yourname这样就不会有提示了