Creating Active X Components

mahulda · May 11th, 2004, 06:43 AM

Here a few lines of Code I obtained from this site
http://www.greggriffiths.org/webdev/...l/activex.html
<script language='VBScript'>
    Dim Xcl

    Sub StartExcel()
        Xcl = CreateObject("Excel.Application")
        Xcl.Visible = true
        dim newBook = Xcl.Workbooks.Add
     end sub
</script>
<body onload="StartExcel()">
</body>

When i run this program I get the following error
System.Exception: Cannot create ActiveX component.

Is there anything wrong with the code ?
If not then How do I enable Active X Components in my Internet Explorer

serup · May 12th, 2004, 12:51 PM

Here is a small example of how to use ActiveX components in IE.
I hope it can help you with your problem.

Sincerely,
Johnny

<HTML>
<HEAD>
<TITLE>ATL 7.0 test page for ActiveX object </TITLE>
</HEAD>
<BODY>

'******************************
'One way of doing it :
'******************************
<OBJECT ID="<name of your ActiveX object>" CLASSID="CLSID:E158200F-877C-456C-A561-061F38E93A74" VIEWASTEXT></OBJECT>
<script language="VBScript">
    <name of your ActiveX object>.About() ' calling a member function inside your ActiveX
</Script>

'******************************
'Another way of doing it :
'******************************
<script language="jscript">
var ActiveXobjectProgId = "name.name.version";

function ActiveXAbout()
{
    var result = true;
    try
    {
        var tp = new ActiveXObject("name.name.version");
    }
    catch(e)
    {
        ActiveXobjectProgId = "name.name";
        tp = new ActiveXObject(ActiveXobjectProgId );
    }

    tp.About();
    return result;
}

ActiveXAbout();
</Script>

</BODY>
</HTML>

Greg Griffiths · January 14th, 2006, 10:00 AM

This is due to the security model on the client machine, check out the links at http://www.greggriffiths.org/webdev/...onclusion.html for info on resolving this issue.