I am trying to open a csv file (which opens in excel). When I run the asp page it gives me "Permission denied: 'CreateObject'
/openExcelTest.asp, line 14" error. I can open a text file in the same directory with no problems. Is there a place I can alow webuser to create an object? the code looks right to me but it won't let me create an excel application object. It is probably very simple but I can't get it to work. All help would be greatly appreciated. Folowing is my code.
/openExcelTest.asp, line 14" error. I can open a text file in the same directory with no problems. Is there a place I can alow webuser to create an object? the code looks right to me but it won't let me create an excel application object. It is probably very simple but I can't get it to work. All help would be greatly appreciated. Folowing is my code.
Code:
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<% Language=VBScript %>
<html>
<head><title>Get Excel File</title>
</head>
<body bgcolor="#333399" text="#CCCCCC" link="#009900" vlink="#0099CC">
<h2>These Items have been ordered</h2>
<%dim objExcel
sub openExcel()
set objExcel = CreateObject("Excel.Application")
objExcel.Workbooks.Open("c:\274\Order.csv")
objExcel.Visible = True
end sub
call openExcel%>
</body></html>