Can't create Excel ActiveX component

[rcarr]

When the user clicks a button I want to create an instance of Excel and display the Open dialog box set to a specific subdirectory. This will give the user a choice of opening one of many spreadsheets in this directory. When I run the following code (the user clicks button1) I get the error, "ActiveX component can't create object :'Excel.Application'". What am I missing?

<SCRIPT LANGUAGE=vbscript>
<!--
Sub button1_onclick()
Set oExcel = CreateObject(&quot;Excel.Application&quot
oExcel.Visible = True
Set fd = oExcel.FileDialog(msoFileDialogFilePicker)
fd.InitialFileName = &quot;\\cc-nts2\data\accounting\&quot;
fd.Filters.Add &quot;*.xls&quot;, &quot;*.xls&quot;, 1
fd.FilterIndex = 2
fd.AllowMultiSelect = False
If fd.Show = -1 Then
oExcel.Workbooks.Open fd.SelectedItems(1)
End If
Set fd = Nothing
Set oExcel = Nothing
End Sub
-->
</SCRIPT>
Randy Carr
randy.carr@carteretcraven.ncemcs.com

 

[rcarr]

OK, I set the security settings to low for this site and it created the Excel object. Now it hangs up on the line &quot;Set fd = oExcel.FileDialog(msoFileDialogFilePicker)&quot;. Anyone have an idea why?
Randy Carr
randy.carr@carteretcraven.ncemcs.com