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.