Hi all,
Does anybody know the syntax for an IF STATEMENT to check if an Excel workbook is already open?
I have a form that opens 5 workbooks before performing various tasks. I want to avoid the message "xyz is already open. Re-opening will cause any changes you made to be discarded. Do you want to reopen xyz?".
Any Thoughts?
Many Thanks.
Cheers - Paul
Does anybody know the syntax for an IF STATEMENT to check if an Excel workbook is already open?
I have a form that opens 5 workbooks before performing various tasks. I want to avoid the message "xyz is already open. Re-opening will cause any changes you made to be discarded. Do you want to reopen xyz?".
Any Thoughts?
Many Thanks.
Cheers - Paul