cum sa aflu dak un fisier e deja deschis?
Last Updated: Mar 06 2008 10:14, Started by
zbudulau00
, Mar 05 2008 12:25
·
0
#1
Posted 05 March 2008 - 12:25
am un fisier excel si vreau sa stiu cand e inchis sau deschis...
|
#2
Posted 06 March 2008 - 10:14
Excel deschide fisierele in mod exclusiv, deci daca aplicatia ta va vrea sa deschida si ea fisierul in mod exclusiv, se va produce o eroare. Aceasta eroare ne spune ca fisierul este deja deschis.
Public Function IsExlFileOpen(strExlFile As String) As Boolean On Error GoTo Err_IsExlFileOpen Dim intFreeFile As Integer intFreeFile = FreeFile Open strExlFile For Binary Access Read Lock Read As #intFreeFile Close #intFreeFile IsExlFileOpen = False Exit_IsExlFileOpen: Exit Function Err_IsExlFileOpen: IsExlFileOpen = True Resume Exit_IsExlFileOpen End Function |
Anunturi
Bun venit pe Forumul Softpedia!
▶ 0 user(s) are reading this topic
0 members, 0 guests, 0 anonymous users