注册 登录
编程论坛 VB6论坛

为什么把textbox里的数据输出到Excel中总是报错“加载dll错误”

凛冬1 发布于 2020-05-15 14:45, 2037 次点击
为什么把textbox里的数据导出到Excel中总是报错“加载dll错误”
程序代码:
Private Sub CmdExport_Click()
Dim xlapp As Excel.Application
Dim xlbook As Excel.Workbook
Dim xlsheet As Excel.Worksheet


 Set xlapp = CreateObject("excel.application")

 Set xlbook = xlapp.Workbooks.Add

 xlapp.Visible = True


 Set xlsheet = xlbook.Worksheets("风机参数")


 xlsheet.Cells(1, 1) = "机号No."

 xlsheet.Cells(1, 2) = "转动方式."

 xlsheet.Range("A2").Value = Text5.Text

 xlsheet.Range("B2").Value = Text6.Text

 xlsheet.Range("C2").Value = Text7.Text

 xlsheet.Range("D2").Value = Text3.Text


 

 Set xlsheet = Nothing

 Set xlbook = Nothing

 xlapp.Quit

 Set xlapp = Nothing
End Sub
2 回复
#2
foreach2020-05-19 14:38
F8测试,看运行到哪一句有错
#3
foreach2020-05-24 13:16
没有引用excel,不能定义Dim xlapp As Excel.Application
1