How to write to the VBE of a closed workbook?

[Guest]

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.

 

[Bob Phillips]

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)

 

[Guest]

Thanks for the reply Bob.

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)