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. |
VBIDE.VBComponent
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. |
VBIDE.VBComponent
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. |
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. |
All times are GMT +1. The time now is 02:27 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com