Msg Box VBA

Closed
Him - Mar 9, 2010 at 07:17 PM
venkat1926 Posts 1864 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 - Mar 9, 2010 at 09:04 PM
Hello,
How to put Msg box in VBA code, using the criteria of wether a seperate file( other than active file) is opened.
Related:

1 reply

venkat1926 Posts 1864 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 810
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
0