How to identify the file is using bt other people when trying to delete it in Excel Macro
Posted on 2011-02-10
See the part that need help below:
For N = 1 To 25
FileToRemove = Offices.Cells(N, 2).Text & "\" & Range("OfficeFolder").Text & "\" & FileName
If ???File is using by other people??? Then ' need help for the coding!!
Comments.Cells(N, 1).Value = "File unremoved"