Created
June 14, 2019 07:07
-
-
Save DuongAQ/a2362ecbb788bf9803fb630a2ad35369 to your computer and use it in GitHub Desktop.
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
Sub CheckIfFileOpen() | |
Dim fileName As String | |
fileName = "C:\Users\marks\Documents\......." 'Tên file kèm đường dẫn | |
'Gọi function kiểm tra file đóng hay mở | |
If IsFileOpen(fileName) = False Then | |
'Câu lệnh thực hiện khi file đang đóng | |
Else | |
'File đang mở hoặc lỗi khác | |
MsgBox fileName & " is already open." | |
End If | |
End Sub |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment