View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
michaelberrier
 
Posts: n/a
Default VBIDE.VBComponent

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.