VBIDE.VBComponent

[michaelberrier]

I'm trying to use a macro to delete all VBA code in a workbook, and the
very beginning starts with "Dim myVBA As VBIDE.VBComponent". This
causes a "User-Defined Type not Defined" error. I've seen that used in
other macros and in a handful of entries on this group, but I can't
make heads or tales of it or how to make it work for me.

[Chip Pearson]

In VBA, go to the Tools menu, choose References, and select
"Microsoft Visual Basic For Applications Extensibility Library".


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com

"michaelberrier" <[email protected]> wrote in message
news:[email protected]...
> I'm trying to use a macro to delete all VBA code in a workbook,
> and the
> very beginning starts with "Dim myVBA As VBIDE.VBComponent".
> This
> causes a "User-Defined Type not Defined" error. I've seen that
> used in
> other macros and in a handful of entries on this group, but I
> can't
> make heads or tales of it or how to make it work for me.
>

[Bob Phillips]

You need to set a reference to the Microsoft Visual Basic for Applications
Extensibility library, Tools>References.

--

HTH

Bob Phillips

(replace xxxx in the email address with gmail if mailing direct)

"michaelberrier" <[email protected]> wrote in message
news:[email protected]...
> I'm trying to use a macro to delete all VBA code in a workbook, and the
> very beginning starts with "Dim myVBA As VBIDE.VBComponent". This
> causes a "User-Defined Type not Defined" error. I've seen that used in
> other macros and in a handful of entries on this group, but I can't
> make heads or tales of it or how to make it work for me.
>

[michaelberrier]

Thanks. If I swear sometimes I can't read.


Bob Phillips wrote:
> You need to set a reference to the Microsoft Visual Basic for Applications
> Extensibility library, Tools>References.
>
> --
>
> HTH
>
> Bob Phillips
>
> (replace xxxx in the email address with gmail if mailing direct)
>
> "michaelberrier" <[email protected]> wrote in message
> news:[email protected]...
> > I'm trying to use a macro to delete all VBA code in a workbook, and the
> > very beginning starts with "Dim myVBA As VBIDE.VBComponent". This
> > causes a "User-Defined Type not Defined" error. I've seen that used in
> > other macros and in a handful of entries on this group, but I can't
> > make heads or tales of it or how to make it work for me.
> >