Check if it is already open, and if so, don't open it

On Error Resume Next
Set oWb = Workbooks("myBook.xls")
On Error Goto 0
If oWb Is Nothing Then
Workbooks.Open ...
`etc.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Steph" wrote in message
...
Hi all I have a stange circumstance. In a perticular file, if a certain
event is true, I would like to open another workbook and run a procedure
within that workbook. Unfortunately, the macro that will be executed is
programmed to open the original workbook.

I'm trying to figure out how to call that macro AFTER a certain criteria
is
met and AFTER the original workbook has closed. Any ideas?