LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 94
Default GetObject

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
GetObject equivalent for IE spaceman Excel Programming 3 December 15th 05 07:30 AM
GetObject error 429 Brian Delaney Excel Programming 3 August 23rd 05 03:37 PM
GetObject function R Avery Excel Programming 3 October 5th 04 07:20 PM
GetObject Michael Excel Programming 3 June 16th 04 01:28 PM
GetObject-question Tom Excel Programming 1 June 10th 04 05:17 PM


All times are GMT +1. The time now is 02:34 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"