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.

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" wrote in message
ups.com...
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.

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

--

HTH

Bob Phillips

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

"michaelberrier" wrote in message
ups.com...
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.

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, ToolsReferences.

--

HTH

Bob Phillips

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

"michaelberrier" wrote in message
ups.com...
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.