Professional Web Applications Themes

forcing Excel to open file - ASP

I have the following code at the top of my page. Is there a way to force Excel to open the spreadsheet? Presently, it opens within the browser window. I know it can be saved etc., but I would rather have Excel receive the data. <% Response.contenttype = "application/vnd.ms-excel" %> <% Response.AddHeader "Content-Disposition", "filename=" & Request.Form("FileName") & ".xls" %> thanks...

  1. #1

    Default forcing Excel to open file

    I have the following code at the top of my page. Is there a way to force
    Excel to open the spreadsheet? Presently, it opens within the browser
    window. I know it can be saved etc., but I would rather have Excel receive
    the data.

    <% Response.contenttype = "application/vnd.ms-excel" %>
    <% Response.AddHeader "Content-Disposition", "filename=" &
    Request.Form("FileName") & ".xls" %>

    thanks


    shank Guest

  2. #2

    Default Re: forcing Excel to open file

    This is a client side option. (Open in new window for the .xls file type),
    but you can use this:

    [url]http://www.aspfaq.com/show.asp?id=2161[/url]

    Ray at work

    "shank" <shanktampabay.rr.com> wrote in message
    news:%23QNnIGmRDHA.1072TK2MSFTNGP10.phx.gbl...
    > I have the following code at the top of my page. Is there a way to force
    > Excel to open the spreadsheet? Presently, it opens within the browser
    > window. I know it can be saved etc., but I would rather have Excel receive
    > the data.
    >
    > <% Response.contenttype = "application/vnd.ms-excel" %>
    > <% Response.AddHeader "Content-Disposition", "filename=" &
    > Request.Form("FileName") & ".xls" %>
    >
    > thanks
    >
    >

    Ray at Guest

Similar Threads

  1. Open a CSV file in MS-Excel via a link
    By McKirahan in forum ASP Database
    Replies: 0
    Last Post: March 4th, 04:32 PM
  2. Forcing pages to open only within a frameset
    By Dan Vendel *GOF* in forum Macromedia Dreamweaver
    Replies: 5
    Last Post: July 16th, 02:04 PM
  3. Forcing File Download Save/Open dialogue
    By rogerwithnell webforumsuser@macromedia.com in forum Macromedia Dreamweaver
    Replies: 3
    Last Post: July 11th, 08:00 PM
  4. Open Excel file in asp
    By Andrew Durstewitz in forum ASP
    Replies: 1
    Last Post: July 9th, 07:59 PM
  5. Forcing form view on open
    By Mark J in forum Microsoft Access
    Replies: 1
    Last Post: July 1st, 04:21 PM

Bookmarks

Posting Permissions

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

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139