Learn Excel Macro Check if file is already open using excel VBA

This function can be used as a Cell Formula as well. In this workbook you can use this function as an excel formula which will take the same input and return TRUE of file is open and FALSE if not. 1. Calling in VBA code Sub Test() ' While passing the File

www.learnexcelmacro.com