1.SaveAs
2.通过数据生成Excel
2.通过数据生成Excel
解决方案 »
- 关于picture菜鸟问题
- 啊...要化了....大家那里现在是什么情况?
- 【问】为什么在ODL里这样申明Enum 通不过?TVM_INSERTITEMA=(TV_FIRST + 0)
- 求助高手:有关日文字符的问题!!急~~~~
- 高分请教如何用VB做播放器
- 请问在vb里如何得到一个窗口的句柄和设备描述表句柄呀?
- 急高分求解,高手请进
- 用VB开发的Webclass开发WEB程序,出现下列错误,能看看吗?
- 请问如何用ADO创建ACCESS数据库,在指定目录下,
- 为何ActiveX DLL 在asp中没有创建成功????
- 急阿,送100分了!有关水晶报表8.0的使用限制问题?
- datagrid 怎样刷新数据。在线等待
Dim I, J As Long
Dim conn As ADODB.Connection
Dim rst As ADODB.RecordsetSet conn = New ADODB.Connection
Set rst = New ADODB.Recordset
conn.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\db1.mdb;Persist Security Info=False"
conn.Openrst.CursorLocation = adUseClientrst.Open "select * from tableabc", conn, adOpenDynamic, adLockOptimistic
Dim MyApp As Excel.Application
Dim MyBook As Excel.Workbook
Dim MySheet As Excel.Worksheet
Set MyApp = CreateObject("Excel.Application")
MyApp.Visible = False
Set MyBook = MyApp.Workbooks.Add()
Set MySheet = MyBook.Worksheets(1)J = 1
Do Until rst.EOF
For I = 1 To rst.Fields.Count
MySheet.Cells(J, I) = rst.Fields(I - 1)
Next
rst.MoveNext
J = J + 1
LoopMyBook.SaveAs "C:\11.xls"MyApp.QuitSet MyApp = Nothingrst.CloseSet rst = Nothing
Set conn = Nothing
End Sub