VBA Assistance needed to test for open file in a different direct
Sub opentest()
For Each wb In Workbooks
If wb.Name = "QA_Accounts_Overview2007" Then
MsgBox ("it is open")
Exit Sub
End If
Next
MsgBox ("it is not open")
End Sub
--
Gary''s Student - gsnu200718
|