Have data to copy from the Active Workbook (with focus) to another Workbook (closed or without focus). Using MSO FileDialog FilPicker I select the other file to open. If it’s not, macro will open it and continue with rest of Sub routine.
Trying to handle if it is already open, if it is - just want to active it, if it’s not macro just continues with the MSO FileDialog selection and opens it.

Problem I’m trying to overcome is if its open but not been saved I have to either, 1)reactivate it but lose previous changes or 2) exit sub – save it and run sub again. Is there any way to handle this within the routine or another way around this.

This is what using
Please Login or Register  to view this content.
Additional lines have experimented with but can’t get things right

Please Login or Register  to view this content.