Home

Consulting

Excel VBA

Legal

Links

Contact

About Us

Make A Read Only File Updatable

'********************************************************************
'  http://www.KravatzInc.com    1-866-XLS-PROG
'
'  This code is copyrighted by Kravatz, Inc. (c) 2007 All Rights Reserved.
'  You may use this code as long as this message appears
'  There is no warranty made to the fitness or suitablilty of this code
'  and by using it you hold Kravatz, Inc. harmless for any damages
'  that may result from its use.  This code is supplied as is.
'  
'********************************************************************
Sub SetFileNotReadOnly(sfile As String)
On Error Resume Next
Dim attr
attr = GetAttr(sfile)
SetAttr sfile, attr - vbReadOnly


End Sub