如果你安装了OFFICE的话:Private Declare Function ShellExecute Lib "shell32.dll" Alias "ShellExecuteA" (ByVal hwnd As Long, ByVal lpOperation As String, ByVal lpFile As String, ByVal lpParameters As String, ByVal lpDirectory As String, ByVal nShowCmd As Long) As Long
Private Sub Command1_Click()
Dim dbs As Database
Set dbs = OpenDatabase(App.Path & "\db1.mdb")
If Dir(App.Path & "\MyExcel.xls") <> "" Then Kill App.Path & "\MyExcel.xls"
dbs.Execute "SELECT * INTO [Excel 8.0;DATABASE=" & App.Path & "\MyExcel.xls].[WorkSheet1] FROM 在校学生"
dbs.Close
Set dbs = Nothing
Shell "C:\Program Files\Microsoft Office\Office\EXCEL.EXE " & App.Path & "\MyExcel.xls", vbMaximizedFocusEnd Sub
Private Sub Command1_Click()
Dim dbs As Database
Set dbs = OpenDatabase(App.Path & "\db1.mdb")
If Dir(App.Path & "\MyExcel.xls") <> "" Then Kill App.Path & "\MyExcel.xls"
dbs.Execute "SELECT * INTO [Excel 8.0;DATABASE=" & App.Path & "\MyExcel.xls].[WorkSheet1] FROM 在校学生"
dbs.Close
Set dbs = Nothing
Shell "C:\Program Files\Microsoft Office\Office\EXCEL.EXE " & App.Path & "\MyExcel.xls", vbMaximizedFocusEnd Sub
解决方案 »
- vb获取已知路径中的相对路径
- vb6中winsock控件接收数据中如何分离文本数据和图片数据?
- 谁能帮我翻译一下,我看不懂,请帮帮忙把
- 讨论一下升级包升级的方法是怎么实现的?
- QQQQQQQQQQQQQQQ............搜索排行榜第一(权当散分)?
- 如何用vb动态添加表?
- 谢谢大家,能不能给小弟一份人力资源管理系统的源代码啊?我急着要交付给客户看看呢,500分
- 关于VB&SQL2000
- 高分请教,VB打包之后的文件必须全要吗?
- 我有个问题请教!
- 如何在vb中用程序建立ODBC---系统DSN?
- 我是一名vb程序员,面对现在vs.net以及java等的语言,我不之选择何种语言最好,请大家给个建议?
例如:Excel 8.0 得装excel2000了,
如果装的是excel97,只能用Excel 5.0