Hi,

I have the following short code to auto open a macro file when teh main fiel is is opened.

-----------------------------------------------------------------
Sub Auto_Open()
'
' Auto_Open Macro


Workbooks.Open Filename:="G:\PUBS\PP-MS\INVOICES\SALEMAC.xlm", Notify:= _
False
ActiveWindow.Visible = False
End Sub

---------------------------------------------------

I want to change this code so that it frst checks if teh file is already open, and only open it if it is not. Can anyone help with it?

Thanks.

Talāt