Necessary to open up one workbook in order to copy information to another workbook?

You are asking Excel to work with 2 different ranges in your modification of the code.

Try changing the range to the right of the = to match the range to the left of the = sign.

In other words use "A7:C7" on both sides of the = sign