Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I have AVAYA CenterVu Supervisor 9.0 Application running and I want to
get that application as an object in my Excel VBA coding and run AVAYA reports through Excel VBA. Dim cvsApp As Object Set cvsApp = GetObject("CVSUP.cvsApplication") The above shows Automation error: Invalid Syntax with END and DEBUG buttons. Dim cvsApp As Object Set cvsApp = GetObject(, "CVSUP.cvsApplication") The above shows Run-time error '429' ActiveX component can't create object If I use Create Object like Dim cvsApp As Object Set cvsApp = CreateObject("CVSUP.cvsApplication") it works fine I don't want to use create object, I will manually login to AVAYA. What is the correct syntax? More info: I have imported and checked all requied references in Tools-References. They all are fine. If I right click on the .exe file of AVAYA software and click properties, I get the following info cvsAPP.exe Type of file: Application Description: cvsApplication Component Location: C:\Program Files\Avaya\CentreVu Supervisor 9.0 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
GetObject equivalent for IE | Excel Programming | |||
GetObject error 429 | Excel Programming | |||
GetObject function | Excel Programming | |||
GetObject | Excel Programming | |||
GetObject-question | Excel Programming |