Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Excel VBA objects missing between 2 differing Excel 2013 32bit installations 1

Status
Not open for further replies.

kitackers

MIS
Apr 16, 2004
33
GB
Hi,

I've got a piece of VBA that logs in to CMS, pulls the data in to the workbook and logs out. This works fine on my (older) desktop PC, but my laptop gives a "run-time error 429 ActiveX component can't create the object" at;

Dim cvsApp As Object, cvsConn As Object, cvsSrv As Object, Rep As Object, Info As Object, Log As Object, b As Object
Set cvsApp = CreateObject("ACSUP.cvsApplication")
Set cvsConn = CreateObject("ACSCN.cvsConnection")
Set cvsSrv = CreateObject("ACSUPSRV.cvsServer")
Set Rep = CreateObject("ACSREP.cvsReport")

Both run Excel 2013 32bit, with the same references selected

Visual Basic for Applications
Microsoft Excel 15.0 Object Library
Microsoft Forms 25.0 Object Library
Microsoft Office 15.0 Object Library
OLE Automation
Microsoft ActiveX Data Objects 6.1 Library

I've tried changing between late and early binding & making them trusted documents but to no avail

Has anyone any suggestions to resolve? Or even point me to what I can copy from one PC to the other?

Thanks
 
Excel isn't to blame here. The missing objects belong to your CMS application

Are you sure all the following Avaya CMS ActiveX components are properly installed and registered on your laptop: Catalog Component, Connection Component , Report Component , Server Component and Application Component
 
Why didn't I think of that?!

Will check when I'm back in work tomorrow....Thank you very much!
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top