Msg Box VBA
Closed
Him
-
9 Mar 2010 à 19:17
venkat1926 Posts 1863 Registration date Sunday 14 June 2009 Status Contributor Last seen 7 August 2021 - 9 Mar 2010 à 21:04
venkat1926 Posts 1863 Registration date Sunday 14 June 2009 Status Contributor Last seen 7 August 2021 - 9 Mar 2010 à 21:04
Related:
- Msg Box VBA
- Vba find - Guide
- Setting up a box account - Guide
- Vba case like - Guide
- Media box apk - Download - Video recording and streaming
- Vba timer - Guide
1 response
venkat1926
Posts
1863
Registration date
Sunday 14 June 2009
Status
Contributor
Last seen
7 August 2021
811
9 Mar 2010 à 21:04
9 Mar 2010 à 21:04
there are many reference in google search. what you need is a function
see this web pagae
http://www.vbaexpress.com/kb/getarticle.php?kb_id=468
copy that function in your vbeditor (function only)
below that put a sub like this
Sub test()
If IsFileOpen("give full path of the file ") Then
msgbox "the file is open"
End If
End Sub
see this web pagae
http://www.vbaexpress.com/kb/getarticle.php?kb_id=468
copy that function in your vbeditor (function only)
below that put a sub like this
Sub test()
If IsFileOpen("give full path of the file ") Then
msgbox "the file is open"
End If
End Sub
