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!


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