标题: [原创技巧]使用GetObject(, "Excel.Application")获到excel对象出错解决 [打印本页] 作者: tmtony 时间: 2014-10-26 13:48 标题: [原创技巧]使用GetObject(, "Excel.Application")获到excel对象出错解决 Access使用GetObject(, "Excel.Application")偶尔提示参数不可选的错误. 最终找到解决办法.与大家分享搜索所有微软的帮助也看不出程序有什么错误,提供的参数也是正确的.
使用方法如下
Dim ExApp As Object
On Error Resume Next
Set ExApp = GetObject(, "Excel.Application")
一般,为了避免引用控件或链接库,大家都比较喜欢不引用直接createobject且使用后期绑定的方式.
Dim excelApp As Object
Set excelApp = CreateObject("Excel.APPLICATION")
如果已经有打开的Excel,则获取当前已打开的
Set ExApp = GetObject(, "Excel.Application")
API函数定义如下:
Public Declare Function GetObject Lib "gdi32" Alias "GetObjectA" (ByVal hObject As Long, ByVal nCount As Long, lpObject As Any) As Long
解决办法,将API函数改成其它名称
Public Declare Function apiGetObject Lib "gdi32" Alias "GetObjectA" (ByVal hObject As Long, ByVal nCount As Long, lpObject As Any) As Long