Hi All,

I actually need help on below codes for closing an open workbook on network.

Am using the following codes :

[vba]
FILE_NAME = FILE_TO_OPEN & ".xls"
Set WBOOK = Workbooks.Open("\\130.1.1.138\FACTORY_WIP\PROGRESS\" & FILE_NAME, ReadOnly:=False)
If WBOOK Is Nothing Then 'Not open
MsgBox "Workbook is not open"

Set WBOOK = Nothing
' On Error GoTo 0
Else
Workbooks.Item(FILE_NAME).Close SAVECHANGES:=False
Set WBOOK = Nothing
'On Error GoTo 0
End If
[/vba]
but the problem is when another user already has it open its giving me readonly or notify msg which i don't want.

can this be done that it do not ask the user for changes but it just close the workbook and continue the other procedure .

thanks for the help.