Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hi, there
I try to create an "Excel.Application" object using CreateObject function, I got "nothing" from the return variable without any error messages, but It works well on another computer, we have the same environment settings(include same references setting) on those 2 computers: Win2k/Sp4, VB6/Sp5, Mdac_type2.7, the following is source code snippet Public appWorld As Excel.Applicatio Public wbWorld As Excel.Workboo Sub Setup() On Error Resume Next 'ignore error Set appWorld = GetObject(, "Excel.Application" If Err.Number < 0 The Set appWorld = CreateObject("Excel.Application") 'run i End I Err.Clea End Su I got "nothing" from "appWorld", even I remark all of error handle lines, the same result I got, pls help me,thanks |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
CreateObject("Excel.Application") | Excel Worksheet Functions | |||
Createobject returns null in Excel | Excel Discussion (Misc queries) | |||
create excel based standalone application | Excel Discussion (Misc queries) | |||
create installer for Excel application | Excel Discussion (Misc queries) | |||
CreateObject("Excel.Application") - Access denied | Excel Programming |