請各位幫幫忙,問題是這樣的:
我要讀寫EXCEL 文件
我已經在VB裡引用了Microsoft office 9.0 object library,它的位置在
C:\Program Files\Microsoft Office\Office\EXCEL9.OLBDim SourceXLS As New Excel.Application
SourceXLS.Workbooks.Open App.Path + "\Source.xls" '出錯
提示載入DLL時發生錯誤。
我要讀寫EXCEL 文件
我已經在VB裡引用了Microsoft office 9.0 object library,它的位置在
C:\Program Files\Microsoft Office\Office\EXCEL9.OLBDim SourceXLS As New Excel.Application
SourceXLS.Workbooks.Open App.Path + "\Source.xls" '出錯
提示載入DLL時發生錯誤。
解决方案 »
- 紧急求助!!!各位大神!!帮我一下吧。
- 推荐一个网站:www.cnpopsoft.com
- XMLHTTP发送和接收方法提问
- 请求帮忙
- 哪位高人给详细解释一下sendmessage函数中的各个参数取值
- 怎样拦截鼠标的双击事件?
- ImageList 是否有其它控件可以替换?
- RecordSet访问前一定要Movefirst吗? 请给明确答案
- 有谁知道在VB中失去焦点的情况下后台监控鼠标左右键的方法吗?知道的话请告诉我。小弟感激不尽。
- 请帮忙改正一个语句!!(谢谢了)
- 数据库查询中如果用DAO,怎么样设计才能实现模糊查询和多从查询
- 请问VB如何可以实现全屏播放一个avi文件,然后打开一个HTML文件呢?请指教,谢谢!
Option ExplicitPrivate Sub cmdStart_Click()
Dim SourceXLS As New Excel.Application
'Dim SourceXLS As Excel.Application
'Set SourceXLS = New Excel.Application '???????
Dim Col1() As String
Dim Col2() As String
Dim Col3() As String
Dim Col4() As String
Dim nRows As Long
Dim n As Long
Dim i As Long
Dim j As Long
Dim sFileName As String
If txtRows.Text = "" Then
MsgBox "請輸入源EXCEL文件的行數!", vbExclamation
Exit Sub
Else
nRows = txtRows.Text
End If
CommonDialog1.DialogTitle = "打開EXCEL文件"
CommonDialog1.Filter = "EXCEL文件(*.xls)|*.xls"
CommonDialog1.ShowOpen
sFileName = CommonDialog1.FileName
'SourceXLS.Workbooks.Open App.Path + "\Source.xls" '打開源文件
SourceXLS.Workbooks.Open sFileName
'read data from Excel
For i = 1 To nRows
Col1(i) = SourceXLS.Worksheets(1).Cells(i, 1)
Col2(i) = SourceXLS.Worksheets(1).Cells(i, 2)
Col3(i) = SourceXLS.Worksheets(1).Cells(i, 3)
Col4(i) = SourceXLS.Worksheets(1).Cells(i, 4)
Next i
End Sub
Dim SourceXLS As Object
Set SourceXLS = CreateObject("Excel.Application")
SourceXLS.Workbooks.Open (App.Path + "\Source.xls")
可以找台别的机器替换自己的EXCEL9.OLB和mso.dll并重新引用
还不行就重启,再不行就重装office