实时错误‘91’:对象变量或With变量未设置这个错误信息最主要的原因是 你没 "工程引用" Microsoft ActiveX Data Objects 2.5 Library
好像只有Microsoft ActiveX Data Objects 2.0 Library ,没有你说的Microsoft ActiveX Data Objects 2.5 Library啊
引用的除了 Microsoft ActiveX Data Objects 2.5 Library 其它的打勾先全部去掉.
Visual Basic For Aplicationgs Visual Basic runtime objects and procedure Visual Basic objects and procedure OLE Automation Microsoft DAO 3.51 object Liarbry Microsoft ActiveX Data objects 2.0 Liarbry Microsoft Excel 11.0 objects Liarbry Microsoft Connection 1.0 Designer Instance 1.0 Microsoft Remote Data objects 2.0 Microsoft Data Binding Collection Microsoft Data Report Designer v6.0 Microsoft Data Formatting object Liarbry 6.0(SP6) Microsoft Data Environment Instance 1.0
Visual Basic For Aplicationgs Visual Basic runtime objects and procedure Visual Basic objects and procedure Microsoft Excel 11.0 objects Liarbry Microsoft ActiveX Data Objects 2.5 Library 你就先这样看它提示 "缺" 什么,你再把它打勾吧
Dim f1 As StdDataFormat 用户定义类型未定义
Microsoft Data Binding Collection Microsoft Data Report Designer v6.0 Microsoft Data Formatting object Liarbry 6.0(SP6) Microsoft Data Environment Instance 1.0 再把这些打勾试看
实时错误‘91’:对象变量或With变量未设置
再把3.51那个加上去Microsoft ActiveX Data objects 2.0 Liarbry '这个肯定不能加,与2.5那个重复了
'--------------------
欢迎来我的小店坐坐:程序员雅琪的小店
Visual Basic runtime objects and procedure
Visual Basic objects and procedure
OLE Automation
Microsoft DAO 3.51 object Liarbry
Microsoft ActiveX Data objects 2.0 Liarbry
Microsoft Excel 11.0 objects Liarbry
Microsoft Connection 1.0 Designer Instance 1.0
Microsoft Remote Data objects 2.0
Microsoft Data Binding Collection
Microsoft Data Report Designer v6.0
Microsoft Data Formatting object Liarbry 6.0(SP6)
Microsoft Data Environment Instance 1.0
Visual Basic runtime objects and procedure
Visual Basic objects and procedure
Microsoft Excel 11.0 objects Liarbry
Microsoft ActiveX Data Objects 2.5 Library 你就先这样看它提示 "缺" 什么,你再把它打勾吧
Microsoft Data Report Designer v6.0
Microsoft Data Formatting object Liarbry 6.0(SP6)
Microsoft Data Environment Instance 1.0 再把这些打勾试看