Hi All,
Firstly, thanks to all for all the great posts that helped me so far in utilizing Excel as a frontend for CMS Supervisor.
I am going through very basic steps in Excel VBA:
Code:
Public Sub CMSConn()
Dim cvsApp As New ACSUP.cvsApplication
Dim cvsConn As New ACSCN.cvsConnection
Dim cvsSrv As New ACSUPSRV.cvsServer
Dim Rep As New ACSREP.cvsReport
Dim Info As Object, Log As Object, b As Object
Set cvsApp = CreateObject("ACSUP.cvsApplication")
Set cvsConn = CreateObject("ACSCN.cvsConnection") <--- Run-time Error '429' at this line
Set cvsSrv = CreateObject("ACSUPSRV.cvsServer")
Set Rep = CreateObject("ACSREP.cvsReport")
I am running Win8 64bit and Office 64bit. I provide these details as I believe this is the main reason of the problem.
Steps taken so far:
1. Made sure all the required References are marked
2. Ran the RegistryDefaults.bat from CMS folder
3. Re-registered cvsCONN.dll with 32bit regsvr32
Unfortunately the app still returns the Run-time Error '429': "ActiveX component can't create object"
There is no problem on tested 32bit system.
Any advice on the reason why this fails would be appreciated.
Best Regards,
Waclaw Bukowski
Topic Author
