Macro to open workbook with a suffix (need help to check if file is already open)

Good Afternoon all,

I am using a small macro within a macro to open a file, the below code opens said file with a suffix to differentiate the file from any others in the folder very useful for adding a date etc.. I need some help finding a way to check if the file is already open before trying to open it again with a macro, I have fond a couple of vba code posts which check if a specific filename is open but none to help with a variable suffix. only one file would be open with the prefix "Planning Tool" at any one time and i was thinking to try and check for something like "Planning Tool*" and if it is open to activate the workbook and not open it again. Any help with an addition to the below code would be very much appreciated, I am a novice at VBA and can not find what i am specifically looking for on the forums, Thanks

Please Login or Register  to view this content.

Thank you AlphaFrog, you got me there, I just had to tweek the code a little to get it to work as expected.

Please Login or Register  to view this content.

Thanks a Million