MrExcel Publishing
Your One Stop for Excel Tips & Solutions

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