Well, this can be done. Although it will take a lot of detail on your part, as in what is coming from where and where it's going to (books, sheets, range). And afaik, the book has to be open to write value(s) to it. But they can be opened at runtime and then closed back down if you don't want them open.