Private Sub Form_Load()
Dim objwork As Excel.Workbook
Dim objexcel As Excel.Application
Set objexcel = objwork.Workbooks.Opening("D:\qq.xls") '就是这句总是报那个错
objexcel.Sheets("Sheet1").Select
End Sub
我已经解决了,是没创建对象,不是OPEN的问题
VB6.0调用EXCEL 提示:对象变量或with块变量未设置,请问怎么回事啊?
答案:2 悬赏:40 手机版
解决时间 2021-02-05 02:54
- 提问者网友:战皆罪
- 2021-02-04 16:01
最佳答案
- 五星知识达人网友:煞尾
- 2021-02-04 16:38
Private Sub Form_Load()
Dim objwork As Excel.Workbook
Dim objexcel As new Excel.Application
Set objwork= objexcel.Workbooks.Open("D:\qq.xls") '就是这句总是报那个错
objwork.Sheets("Sheet1").Select
End Sub
Dim objwork As Excel.Workbook
Dim objexcel As new Excel.Application
Set objwork= objexcel.Workbooks.Open("D:\qq.xls") '就是这句总是报那个错
objwork.Sheets("Sheet1").Select
End Sub
全部回答
- 1楼网友:山河有幸埋战骨
- 2021-02-04 16:50
dim xlapp as excel.application
dim xlbook as excel.workbook
dim xlsheet as excel.worksheet
set xlapp = createobject("excel.application")
dim ss as string
commondialog1.showopen
ain = commondialog1.filename
if ain = "" then exit sub
ain = "d:\a.xls"
set xlbook = xlapp.application.workbooks.open(ain)
set xlsheet = xlbook.worksheets(1)
max = 0
g = val(text1.text)
redim b(g, 3)
redim preserve strc(g, 5)
redim strd(g)
str = xlsheet.cells(i, 2)
我要举报
如以上问答信息为低俗、色情、不良、暴力、侵权、涉及违法等信息,可以点下面链接进行举报!
大家都在看
推荐资讯