Hello all,

Anyone work with the VBE object before? If you have can you give me any ups
and downs about it and more, some good links on this subject? After finding
that Office does have an Object for the Macro Editor I would like to know
what are the limitations?

Thanks,

Jeff Mathewson

Re: VBA VBE Object by Shauna

Shauna
Wed Jun 27 05:41:37 CDT 2007

Hi Jeff

The VBA help files have reasonably good information about the VBE object and
see http://www.cpearson.com/excel/vbe.htm.

The most important thing is that you have to tell Word explicitly that you
want to run code against the VBE object. In Word 2003, do Tools > Options >
Security. Click Macro Security, and on the "Trusted publishers" tab, tick
the box that says "Trust access to Visual Basic project".

Hope this helps.

Shauna Kelly. Microsoft MVP.
http://www.shaunakelly.com/word


"Jeff Mathewson" <jeffwm@uswest.net> wrote in message
news:OnEjOmFuHHA.4948@TK2MSFTNGP06.phx.gbl...
> Hello all,
>
> Anyone work with the VBE object before? If you have can you give me any
> ups
> and downs about it and more, some good links on this subject? After
> finding
> that Office does have an Object for the Macro Editor I would like to know
> what are the limitations?
>
> Thanks,
>
> Jeff Mathewson
>
>
>



Re: VBA VBE Object by Jeff

Jeff
Wed Jun 27 08:03:18 CDT 2007

Thanks for the reply,

The second question to this would be if Word 2007 supports this. Has
Microsoft brought the full power of Office VBA into Word? I myself am more
into Excel, but I'm going to be having to dig deep into Word 2007.

Jeff Mathewson

"Shauna Kelly" <ShaunaKelly@SendNoSpamToShaunaKelly.com> wrote in message
news:%23UUuKfKuHHA.1768@TK2MSFTNGP04.phx.gbl...
> Hi Jeff
>
> The VBA help files have reasonably good information about the VBE object
and
> see http://www.cpearson.com/excel/vbe.htm.
>
> The most important thing is that you have to tell Word explicitly that you
> want to run code against the VBE object. In Word 2003, do Tools > Options
>
> Security. Click Macro Security, and on the "Trusted publishers" tab, tick
> the box that says "Trust access to Visual Basic project".
>
> Hope this helps.
>
> Shauna Kelly. Microsoft MVP.
> http://www.shaunakelly.com/word
>
>
> "Jeff Mathewson" <jeffwm@uswest.net> wrote in message
> news:OnEjOmFuHHA.4948@TK2MSFTNGP06.phx.gbl...
> > Hello all,
> >
> > Anyone work with the VBE object before? If you have can you give me any
> > ups
> > and downs about it and more, some good links on this subject? After
> > finding
> > that Office does have an Object for the Macro Editor I would like to
know
> > what are the limitations?
> >
> > Thanks,
> >
> > Jeff Mathewson
> >
> >
> >
>
>



Re: VBA VBE Object by Shauna

Shauna
Thu Jun 28 02:35:03 CDT 2007

Hi Jeff

Microsoft introduced VBA to Word in Word 97, and it hasn't gone away yet.
Whether that constitutes the "full power", I don't think I'd want to guess.

Hope this helps.

Shauna Kelly. Microsoft MVP.
http://www.shaunakelly.com/word


"Jeff Mathewson" <jeffwm@uswest.net> wrote in message
news:eFNs8oLuHHA.536@TK2MSFTNGP06.phx.gbl...
> Thanks for the reply,
>
> The second question to this would be if Word 2007 supports this. Has
> Microsoft brought the full power of Office VBA into Word? I myself am
> more
> into Excel, but I'm going to be having to dig deep into Word 2007.
>
> Jeff Mathewson
>
> "Shauna Kelly" <ShaunaKelly@SendNoSpamToShaunaKelly.com> wrote in message
> news:%23UUuKfKuHHA.1768@TK2MSFTNGP04.phx.gbl...
>> Hi Jeff
>>
>> The VBA help files have reasonably good information about the VBE object
> and
>> see http://www.cpearson.com/excel/vbe.htm.
>>
>> The most important thing is that you have to tell Word explicitly that
>> you
>> want to run code against the VBE object. In Word 2003, do Tools > Options
>>
>> Security. Click Macro Security, and on the "Trusted publishers" tab, tick
>> the box that says "Trust access to Visual Basic project".
>>
>> Hope this helps.
>>
>> Shauna Kelly. Microsoft MVP.
>> http://www.shaunakelly.com/word
>>
>>
>> "Jeff Mathewson" <jeffwm@uswest.net> wrote in message
>> news:OnEjOmFuHHA.4948@TK2MSFTNGP06.phx.gbl...
>> > Hello all,
>> >
>> > Anyone work with the VBE object before? If you have can you give me
>> > any
>> > ups
>> > and downs about it and more, some good links on this subject? After
>> > finding
>> > that Office does have an Object for the Macro Editor I would like to
> know
>> > what are the limitations?
>> >
>> > Thanks,
>> >
>> > Jeff Mathewson
>> >
>> >
>> >
>>
>>
>
>