Hello and welcome to our community! Is this your first visit?
Register
Enjoy an ad free experience by logging in. Not a member yet? Register.
Results 1 to 3 of 3
  1. #1
    New to the CF scene
    Join Date
    Nov 2007
    Posts
    3
    Thanks
    0
    Thanked 0 Times in 0 Posts

    how to view excel file with ASP code

    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 ^-^

  • #2
    Regular Coder
    Join Date
    Sep 2007
    Posts
    120
    Thanks
    0
    Thanked 3 Times in 3 Posts
    And how is this ASP related?


    Tom

  • #3
    New to the CF scene
    Join Date
    Nov 2007
    Posts
    3
    Thanks
    0
    Thanked 0 Times in 0 Posts
    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")


  •  

    Posting Permissions

    • You may not post new threads
    • You may not post replies
    • You may not post attachments
    • You may not edit your posts
    •