streaming excel read only

[Fred]

I am streaming an excel pivot table to the browswer using ASP. If "myfile"
is locked for editing, the stream operation fails. How do I either enable
the "Read Only", "Notify", etc dialog box that you get when opening a locked
workbook, or force the file to open Read Only?
******
Response.ContentType = "application/vnd.ms-excel"
Const adTypeBinary = 1
Dim strFilePath
strFilePath = "mypath\myfile"
Set objStream = Server.CreateObject("ADODB.Stream")
objStream.Open
objStream.Type = adTypeBinary
objStream.LoadFromFile strFilePath
Response.BinaryWrite objStream.Read
objStream.Close
Set objStream = Nothing
*********