I don't think you can, you would need to open it, write to it, and close it.

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"DaveO" wrote in message
...
I'd like to add a new module to an existing workbook.

I know how to write to an open workbook's VBE, but how do you do this to a
workbook which is closed? How would I go about referencing the Workbook?

Is it even possible?

TIA.