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
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