1,451
社区成员
发帖
与我相关
我的任务
分享
Public Sub openExcel()
'设置对话框属性,用于指定EXCEL文件
CommonDialog1.Filter= “Excel文件 * .xls”
CommonDialog1.Action= 1
If CommonDialog1.FileName< > “” Then
expath= CommonDialog1.FileName
'打开对话框指定的EXCEL工作簿
Workbooks.Open FileName:= expath
oldbook.Close
Else
End If
End Sub
Option Explicit
'声明变量为EXCEL应用程序对象
Private oldXls As Excel.Application
'声明变量为EXCEL工作簿对象
Private oldBook As Excel.Workbook
'声明变量为EXCEL工作表对象
Private oldSheet As Excel.Worksheet
'编写连接EXCEL的子程序(名为joinExcel)
Private Sub CmdJoinExcel_Click()
On Error Resume Next
Set oldXls = GetObject(, "Excel.Application")
If oldXls Is Nothing Then
Set oldXls = CreateObject("excel.Application")
End If
If oldXls Is Nothing Then
MsgBox "无法创建Excel对象!!!"
Exit Sub
End If
If Not oldXls.Visible Then oldXls.Visible = True
MsgBox "Excel已经准备好,可以打开文件了!"
End Sub
'编写打开EXCEL文件的子程序openExcel
Private Sub CmdOpenExcel_Click()
'设置对话框属性,用于指定EXCEL文件
On Error GoTo 100
Dim exPath As String
With CommonDialog1
.Filter = "*.xls"
.ShowOpen
exPath = .FileName
End With
If exPath = "" Then Exit Sub
'打开对话框指定的EXCEL工作簿
Set oldBook = oldXls.Workbooks.Open(FileName:=exPath)
MsgBox "指定的工作簿已经打开了---" & exPath
Exit Sub
100:
MsgBox Err.Description
End Sub
。。。
代码都放在一个form里即可。'在全局模块通用段声明变量为EXCEL对象
'声明变量为EXCEL应用程序对象
Public oldxls As Excel.Application
'声明变量为EXCEL工作簿对象
Public oldbook As Excel.Workbook
'声明变量为EXCEL工作表对象
Public oldsheet As Excel.Worksheet
'编写连接EXCEL的子程序(名为joinExcel)
Private Sub CmdJoinExcel_Click()
On Error Resume Next
Set oldxls = GetObject(App.Path, "Excel.Application")
If Err Then
Err.Clear
Set oldxls = CreateObject("excel.Application")
If Err Then
Exit Sub
End If
End If
oldxls.Visible = True
Set oldbook = oldxls.Workbooks.Add
Set oldsheet = oldbook.Worksheets(1)
End Sub
'编写打开EXCEL文件的子程序openExcel
Private Sub CmdOpenExcel_Click()
'设置对话框属性,用于指定EXCEL文件
If Err Then
Err.Clear
End If
CommonDialog1.Filter = "Excel文件 * .xls"
CommonDialog1.Action = 1
If CommonDialog1.FileName <> "" Then
expath = CommonDialog1.FileName
'打开对话框指定的EXCEL工作簿
Workbooks.Open FileName:=expath‘这句出错,xp系统48错误,win7系统运行429错误,求指导
If Err Then
Exit Sub
End If
oldbook.Close
Else
End If
End Sub
Option Explicit
Private mExcel As Excel.Application
Private Sub Command1_Click()
Set mExcel = New Excel.Application
mExcel.Visible = True
Dim S1 As String
S1 = "d:\6.xls"
mExcel.Workbooks.Open FileName:=S1
End Sub
执行后可以看到打开的6.xls文件。
你那个excel是不是加载了一些加载项或加载宏等其它外部dll?
你还是上全部代码和错误图示吧,不太好猜测的.......