Option ExplicitDim e As Excel.ApplicationPrivate Sub Command1_Click() Set e = New Excel.Application e.Visible = True Dim i As Long For i = 1 To 1000000 Next e.Quit Set e = NothingEnd Sub
vb没有像java的垃圾收集器,所以要显式的设置为nothing
多谢指教!另外怎么操作excel合并了的单元格!!