Run macro in another file
 

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?

Run macro in another file
 

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?