View Full Version : how to view excel file with ASP code

11-22-2007, 07:54 AM
if let say I have 12 excel file name january to december.
and what I want is when i click on january then the january.xls file will be shown in the explorer. can only read, cannot do any modifycation on it.
Please help me ^-^

Whatever Jr.
11-22-2007, 09:42 AM
And how is this ASP related?


11-23-2007, 03:13 AM
sorry I don't get what you mean?
may be I can show you some code that I have.
I try to run it and it come out with error:
Error Type:
Server object, ASP 0178 (0x80070005)
The call to Server.CreateObject failed while checking permissions. Access is denied to this object.

below is the script:
Set objConn = Server.CreateObject("ADODB.Connection")
Set objInputXLS = Server.CreateObject("Excel.Application")
Set ObjInputWorkBook = objInputXLS.Workbooks.Open(Server.MapPath("Excel") & "\" & Trim(Request.QueryString("FileName")) & ".xls")