VBA calling VBS gives "ActiveX component cant create object"
VBA calling VBS gives "ActiveX component cant create object"
(OP)
Hi folks,
I am a newbie in using VB family of languages. I wrote a .NET dll which creates a process (objProcess.Start()) in one function and returns the pid and then in second function I pass the pid and monitor it using objProcess.WaitForExit(). I exposed it to the COM and registered it using REGASM with /tlb and /Codebase option. Then wrote a small VB script as shown: Lets call is TEST.vbs
I double click the TEST.vbs and it launches the calc adn when I close cals it pops up the message. Everything is good till now :thumb:
Now I want to call this script from and out look macro, so I created one in outlook
If I do this I get the following error
Why the script is running fine by itself and not when called from an Outlook Macro.
Help will be highly appreciated.
HN
I am a newbie in using VB family of languages. I wrote a .NET dll which creates a process (objProcess.Start()) in one function and returns the pid and then in second function I pass the pid and monitor it using objProcess.WaitForExit(). I exposed it to the COM and registered it using REGASM with /tlb and /Codebase option. Then wrote a small VB script as shown: Lets call is TEST.vbs
CODE
Set objProc = CreateObject("CreateANDMonitor.Class1")
pid = objProc.fncCreate("calc.exe")
objProc.fncMonitor(pid)
msgbox "process ended"
Set objProc = Nothing
pid = objProc.fncCreate("calc.exe")
objProc.fncMonitor(pid)
msgbox "process ended"
Set objProc = Nothing
I double click the TEST.vbs and it launches the calc adn when I close cals it pops up the message. Everything is good till now :thumb:
Now I want to call this script from and out look macro, so I created one in outlook
CODE
Public Sub main()
Shell "wscript C:\.....\TEST.vbs"
End Sub
Shell "wscript C:\.....\TEST.vbs"
End Sub
If I do this I get the following error
CODE
MSG: ActiveX component cant create object: "CreateANDMonitor.Class1"
CODE: 800A01AD
CODE: 800A01AD
Why the script is running fine by itself and not when called from an Outlook Macro.
Help will be highly appreciated.
HN
Talk To Other Members
RE: VBA calling VBS gives "ActiveX component cant create object"
regsvr32 dllpath
RE: VBA calling VBS gives "ActiveX component cant create object"