I am opening a file with a macro and the file I am opening has a msgbox that opens right a way. I would like to close it so that my macro process can continue.
Can this be done?
<Sub open_File_Button()
SaveLocation (False)
On Error Resume Next
Workbooks(fname).Activate
'If Excel cannot activate the book, then it's not open, which will
' in turn create an error not of the value 0 (no error)
If Err = 0 Then
'Exit Sub 'Exit macro if no error
SaveLocation (True)
End If
Err.Clear 'Clear erroneous errors
Workbooks.Open fpath & fname
UserForm_File_Is_Open.Show
End Sub
Bookmarks