How to write to the VBE of a closed workbook?

[DaveO]

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)

"DaveO" <[email protected]> wrote in message
news:[email protected]...
> 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.

[DaveO]

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" <[email protected]> wrote in message
> news:[email protected]...
> > 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.
>
>
>