GetObject

M

Maxi

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Working outlook via vba code with xlsx - error 0
AVAYA CMS Scripting through Excel VBA 5
Help with CMS Script(ver 13) using VBA 3
Closing PDF file from Excel VBA (Adobe Reader, Adobe Acrobat, Browser) 0
Getting objects other than 'Excel.Application using GetObject() 0
Search and Replace patterns of strings with a RULE with any new message received. 0
VB code to open other applications from templates 6
Problems with VBA mailmerge 1

Top