On open, check if workbook is open, if not open it

[John_McClane]

Hi Guys,

I have another question for you after you've helped me so much with other things.

I have a spreadsheet 'Training Compliancy.xls' that takes data from a cell in another spreadsheet in the same folder called 'Training Monitoring.xls'

I have been using this code to open 'Training Monitoring.xls' and close it again in the background when you open 'Training Compliancy.xls' so that you won't get any failed values.

Private Sub Workbook_Open()
Application.ScreenUpdating = False



   Workbooks.Open Filename:= _
        "C:\****\John\********\Training\Training Monitoring.xls"
    ActiveWindow.Close False
End Sub

Which works perfectly, provided I don't already have Training Monitoring.xls already open. Is there a way for excel to check if it's open?

If it is, it should do nothing.
If it isn't, it should open it.

Thank you in advance.

 

[Joe4]

Here are a few links that show different ways of doing this:
http://www.mrexcel.com/forum/excel-...open-excel-file-only-if-not-already-open.html
http://www.mrexcel.com/forum/excel-...-if-workbook-already-opened-another-user.html
http://www.mrexcel.com/forum/excel-...e-already-open-visual-basic-applications.html