点解你的这么复杂的,我的这样,可是没有出错
=========================================================
Private Sub Form_Click()
Dim excelApp As Excel.Application
Set excelApp = New Excel.Application
On Error Resume Next
excelApp.Visible = True
excelApp.Workbooks.Add
With excelApp.ActiveSheet
Dim i As Integer, j As Integer
For i = 1 To 10
For j = 1 To 10
.Cells(i, j).Value = "A"
Next j
DoEvents
Next i
End With
Set excelApp = NothingEnd Sub
=========================================================
Private Sub Form_Click()
Dim excelApp As Excel.Application
Set excelApp = New Excel.Application
On Error Resume Next
excelApp.Visible = True
excelApp.Workbooks.Add
With excelApp.ActiveSheet
Dim i As Integer, j As Integer
For i = 1 To 10
For j = 1 To 10
.Cells(i, j).Value = "A"
Next j
DoEvents
Next i
End With
Set excelApp = NothingEnd Sub
解决方案 »
- 下面是vb和sql数据库结合的代码,点击按钮原意想通过判断条件后,改变sql数据库中的值,可点击按钮后无反应,求解答
- 新手求教
- vb的窗体中使用WebBrowser后弹出“安全警报”的安装证书提示
- 怎么才能让所有密码都显示同样个数的*?
- 打印MSHFLEXGRID的问题
- 请教各位大侠:如何用VB建立这样一个小程序:点一下这个程序的图标就弹出一个IE浏览器,同时IE浏览器访问我指定的首页。谢谢!
- 哪里有漂亮的tab控件下载?XP效果那种,免费不免费无所未,好看第一!知道的进来领分吧
- 熟悉socket api 的同志请进来?!
- 怎么才能让ToolTipText中的文字内容换行?
- 把active report 生成的报表导出成excel格式或html格式
- 谁能教我用CommonDialog??高分赠送呀......谢谢
- 做过PC/SC的请进。200分求解winscard.dll调用问题。在线等......
这是什么东西?