I have an application running VBA forms in an Excel workbook. I need to be sure that another workbook is also open in Excel. Is there a function which returns true or false for an open file? Anyone aware of a way of doing this? Thanks.
I have an Excel VBA project application which is designed around User Forms for data entry and internal calculation, with some help from various worksheets in the workbook. There is a need for users to be able to access Excel while the User Form is active. This doesn't appear to be possible...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.