Open workbook.xls with IF function

Posted by EENARMIGE BANDIET on September 10, 2001 12:54 AM

What's the formula with the IF function to see if a workbook is open.
If it isn't open then open it!
How to do this? Let's say the filename of the workbook is workbook.xls!

Thanks

Posted by Juan Pablo on September 10, 2001 6:53 AM

You can't do this with a IF Formula, you have to do this in a VB Macro.

Juan Pablo