VBA can get data from a closed workbook using techniques like shown here http://j-walk.com/ss/excel

Worksheet formula functions can get data from a closed workbook--VLOOKUP, MATCH and INDEX being three particularly useful ones for this purpose.

But I don't know any way to write to a closed workbook. I think you'll have to open it first.

Cheers!

Brad