Msg Box VBA
Closed
Him
-
Mar 9, 2010 at 07:17 PM
venkat1926 Posts 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 - Mar 9, 2010 at 09:04 PM
venkat1926 Posts 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 - Mar 9, 2010 at 09:04 PM
Related:
- Msg Box VBA
- Vba case like - Guide
- Number to words in excel formula without vba - Guide
- Tweak box - Download - App downloads
- Hbo box for pc - Download - Movies, series and TV
- How to tick a box in word mac - Guide
1 response
venkat1926
Posts
1863
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
811
Mar 9, 2010 at 09:04 PM
Mar 9, 2010 at 09:04 PM
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
