how to unset/reset ReadOnly mode of an Excel file?

[Ron]

Hello,

the following sub (below) reads an excel file to a webpage
using BinaryReader. If anyone tries to modify the excel
file from the browser this places the excel file in
ReadOnly mode, and no one can then touch the file, I can't
delete it, etc. The file will still display on the
browser. The only way I have been able to release the
file from ReadOnly mode is to reboot the server computer.
Obviously, I can't keep doing that. Does anyone know if
there is a way to reset/unset the ReadOnly mode of the
Excel file? or how to make it not go into ReadOnly mode?

------------------------------------------------------
Private Sub GetFile()
Dim FilePath As String = Cache("strFile" ).ToString
If Not Dir(FilePath).E quals("") Then
Dim fs As New FileStream(File Path, FileMode.Open,
FileAccess.Read )
Dim bw As New System.IO.Binar yReader(fs)
Dim byt() As Byte, i As Integer
byt = bw.ReadBytes(CI nt(fs.Length))
i = byt.Length()
Response.Conten tType = "applicatio n/vnd.ms-excel"
Response.Output Stream.Write(by t, 0, i)
Response.Output Stream.Close()
response.write( "testing")
End If
End Sub
----------------------------------------------------------

Thanks,
Ron

[Herfried K. Wagner [MVP]]

"Ron" <an*******@disc ussions.microso ft.com> schrieb:

the following sub (below) reads an excel file to a webpage
using BinaryReader. If anyone tries to modify the excel
file from the browser this places the excel file in
ReadOnly mode, and no one can then touch the file, I can't
delete it, etc. The file will still display on the
browser. The only way I have been able to release the
file from ReadOnly mode is to reboot the server computer.
Obviously, I can't keep doing that. Does anyone know if
there is a way to reset/unset the ReadOnly mode of the
Excel file? or how to make it not go into ReadOnly mode?

You can try to specify 'FileShare.Read Write' in the constructor of your
'FileStream'. Maybe this helps.

--
M S Herfried K. Wagner
M V P <URL:http://dotnet.mvps.org/>
V B <URL:http://dotnet.mvps.org/dotnet/faqs/>

[Ron]

Thanks. I will give that a try.

-----Original Message-----
"Ron" <an*******@disc ussions.microso ft.com> schrieb:

the following sub (below) reads an excel file to a webpage using BinaryReader. If anyone tries to modify the excel
file from the browser this places the excel file in
ReadOnly mode, and no one can then touch the file, I can't delete it, etc. The file will still display on the
browser. The only way I have been able to release the
file from ReadOnly mode is to reboot the server computer. Obviously, I can't keep doing that. Does anyone know if
there is a way to reset/unset the ReadOnly mode of the
Excel file? or how to make it not go into ReadOnly mode?
You can try to specify 'FileShare.Read Write' in the

constructor of your'FileStream' . Maybe this helps.

--
M S Herfried K. Wagner
M V P <URL:http://dotnet.mvps.org/>
V B <URL:http://dotnet.mvps.org/dotnet/faqs/>

.