Macro open file and go back

Sorry!

You have to specifiy the worksheets, too.

WBDest.Worksheets(1).Range("F382") = WBSrc.Worksheets(2).Range("E9")

or

WBDest.Worksheets("Report").Range("G382") = WBSrc.Worksheets("Source").Range("F9")