VBIDE.VBComponent

  • Thread starter Thread starter michaelberrier
  • Start date Start date
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.
 
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
 
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)
 
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...
 
Back
Top