Force Download fails when I select "Open" but works fine when I select "Save"

[Michael]

I have a problem forcing files to download. If I select Save the document is
saved with no problems. If I select "Open" the document is empty or I get a
"File not found" error from the application opening the file...

Code:

function UTIL_ForceDownl oadFile(strFile Name, strFileSaveName )
Response.Buffer = True
Dim strFileSize
Const adTypeBinary = 1
Response.Clear

'#Code Find File Size
dim fso, fileObject
Set fso = Server.CreateOb ject("Scripting .FileSystemObje ct")
Set fileObject = fso.GetFile(Ser ver.MapPath(str FileName))
strFileSize = fileObject.Size
Set fileObject = Nothing
Set fso = Nothing

dim objStream, strFileType, ContentType
Set objStream = Server.CreateOb ject("ADODB.Str eam")
objStream.Open
objStream.Type = adTypeBinary
objStream.LoadF romFile Server.MapPath( strFileName)

strFileType = lcase(Right(str FileName, 4))

Select Case strFileType
Case ".asf"
ContentType = "video/x-ms-asf"
Case ".avi"
ContentType = "video/avi"
Case ".doc"
ContentType = "applicatio n/msword"
Case ".zip"
ContentType = "applicatio n/zip"
Case ".xls"
ContentType = "applicatio n/vnd.ms-excel"
Case ".gif"
ContentType = "image/gif"
Case ".jpg", "jpeg"
ContentType = "image/jpeg"
Case ".wav"
ContentType = "audio/wav"
Case ".mp3"
ContentType = "audio/mpeg3"
Case ".mpg", "mpeg"
ContentType = "video/mpeg"
Case ".rtf"
ContentType = "applicatio n/rtf"
Case ".pdf"
ContentType = "applicatio n/pdf"
Case ".htm", "html"
ContentType = "text/html"
Case ".asp"
ContentType = "text/asp"
Case ".txt"
ContentType = "text/plain"
Case Else
ContentType = "applicatio n/octet-stream"
End Select

Response.AddHea der "Content-Disposition", "attachment ; filename=" &
strFileSaveName
Response.AddHea der "Content-Length", strFileSize

Response.Conten tType = ContentType
Response.Charse t = "UTF-8"
Response.Binary Write objStream.Read
Response.Flush
objStream.Close
Set objStream = Nothing
response.end
end function