I need help to come up with a code to copy a data from a shared drive: G:\Source Data.xlsb, sheet 1 from B6:F and then copy to C:\Target Data.xlsb, sheet 2 from A2:E.

If Source Data is OPEN, save it first before copying. Keep it open. If Source Data is close, open it then copy, then close but do not save.

Hope anyone can help me on this code.

Thank you.