VBIDE.VBComponent

M

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.
 
C

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
 
B

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)
 
M

michaelberrier

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


Bob said:
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)
Click to expand...
 
Top