| Home |
| Search |
| Today's Posts |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
VBIDE.VBComponent
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. |
Threaded Mode
