How to write to the VBE of a closed workbook?
 

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.

How to write to the VBE of a closed workbook?
 

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.

How to write to the VBE of a closed workbook?
 

Thanks for the reply Bob.

"Bob Phillips" wrote:

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.