How Can I Tell if an Excel Workbook is Open and, If It Isn’t, Open It?
Hey, Scripting Guy! How can I tell if a specific Excel workbook is open and, if it isn’t, open it? — RK Hey, RK. Every now and then we see a question and think, “We should answer this one; it’s so easy it won’t take more than a few minutes to finish the column and then we can all take a nice long lunch.” At some point you’d think we’d learn that every time we say that it turns out that the problem isn’t as easy as it first looked, and that the column takes far more than just a few minutes to complete. But, no, we never do learn, which is why we’re still hard at work trying to answer this question. Of course, we still plan on taking a nice long lunch, but that’s another story. How did we get fooled on this one? Well, we knew Excel has a Workbooks collection that returns a list of all the open workbooks. Foolishly, we assumed this meant all the open workbooks. (And, yes, we know what people say about assuming things.) Unfortunately, though, the Workbooks collection applies only to a spe
