Asp streaming excel file - file name

[jim]

I'm trying to stream a html page to the user as an excel
file.
I'm currently using
Response.Conten tType = "applicatio n/vnd.ms-excel"
Response.AddHea der "Content-Disposition", "inline;
filename=downlo ad.xls "

The actual streaming and excel file are working fine but
in excel its not picking up the filename its actually
showing up as the url to the page that downloads this. I
would like to show up as download.xls or something similar
even if the path points to the web directory. Any help
would be greatly appreciated.
Thanks
Jim

[Egbert Nierop \(MVP for IIS\)]

You might like this :)
It is token from some script you might change things but you'll get the
idea. Use Content-Disposition; attachment and not 'inline'...

Response.Buffer = False
Set the content type to the specific type that you are sending.
Response.Conten tType = "applicatio n/vnd.ms-excel"

Dim strFilePath, lSize, lBlocks
Const CHUNK = 2048

objStream.Open
objStream.Type = 1
objStream.LoadF romFile strFilePath
lSize = objStream.Size
Response.AddHea der "Content-Length", lSize
Response.AddHea der "Content-Disposition", "attachment ; filename=" + strFile
lBlocks = 1
For lBlocks = lBlocks To lSize \ CHUNK
If Response.IsClie ntConnected = False Then Exit For
Response.Binary Write objStream.Read( CHUNK)
Next
lSize = lSize MOD CHUNK
If lSize > 0 And Response.IsClie ntConnected = True Then
Response.Binary Write objStream.Read( lSize)
End If
'
objStream.Close
'<!--object id="objStream" progid="ADODB.S tream" runat="server"> </object-->
%>

--
compatible web farm Session replacement for Asp and Asp.Net
http://www.nieropwebconsult.nl/asp_session_manager.htm

"jim" <ji********@nos pamforum-financial.com> wrote in message
news:0e******** *************** *****@phx.gbl.. .

I'm trying to stream a html page to the user as an excel
file.
I'm currently using
Response.Conten tType = "applicatio n/vnd.ms-excel"
Response.AddHea der "Content-Disposition", "inline;
filename=downlo ad.xls "

The actual streaming and excel file are working fine but
in excel its not picking up the filename its actually
showing up as the url to the page that downloads this. I
would like to show up as download.xls or something similar
even if the path points to the web directory. Any help
would be greatly appreciated.
Thanks
Jim

[Ray at]

Hmm, so then how will it get the filename of a file that doesn't exist. One
thing you could do is name your .asp file with a .xls extension and then
setup the mapping in IIS to have .xls file executed as asp files.

Ray at work

"Jim" <ji********@nos pamforum-financial.com> wrote in message
news:07******** *************** *****@phx.gbl.. .

I'm actually creating the file on the fly. So the file
doesn't exist on the server. Sorry I didn't specifiy that.
Thanks for the quick response.

-----Original Message-----
In that case, just link to the .xls file itself.

Ray at work

"jim" <ji********@nos pamforum-financial.com> wrote in

message

news:0e******* *************** ******@phx.gbl. ..

I'm trying to stream a html page to the user as an excel
file.
I'm currently using
Response.Conten tType = "applicatio n/vnd.ms-excel"
Response.AddHea der "Content-Disposition", "inline;
filename=downlo ad.xls "

The actual streaming and excel file are working fine but
in excel its not picking up the filename its actually
showing up as the url to the page that downloads this. I
would like to show up as download.xls or something similar even if the path points to the web directory. Any help
would be greatly appreciated.
Thanks
Jim

.

[Jim]

??????????????? ??????????????? ??????????????? ??????????????? ??????????????? ??????????????? ??????????????? ??????????????? ??????????????? ??????????????? ??????????????? ??????????????? ??????????????? ??????????????? ??????????????? ??????????????? ??????????????? ??????????????? ??????????????? ??????????????? ??????????????? ?????.????????? ??????????????? ??????????????? ??????????????? ??????????????? ??????????????? ??????????????? ??????????????? ??????????????? ??????????????? ??????????????? ??????????????? ??????????????? ??????????????? ??????????????? ??????????????? ??????????????? ??????????????? ??????????????? .?????????????? ??????????????? ??????????????? ??????????????? ??????????????? ??????????????? ??????????????? ??????????????? ??????????????? ??????????????? ??????????????? ??????????????? ??????????????? ??????????????? ??????????????? ??????????????? ??????????????? ??????????????? ??????????????? ??????????????? ??????????????? ??????????????? ??????????????? ??????????????? ?>