is there any access VBA code to check if an workbook is open or not open ?
In excel VBA - you could just loop through all the excel files that are open and you find the name of the file while you loop through and you could tell if that file is open. I couldn't do this in Access VBA.
In excel VBA - you could just loop through all the excel files that are open and you find the name of the file while you loop through and you could tell if that file is open. I couldn't do this in Access VBA.