我让VBA代码循环遍历文件,并使用VBIDE删除了代码。但是,一直无法获得控件的句柄。以下是我一直在使用的对象,而不是浪费时间在我尝试过的代码上:Dim VBComp As VBIDE.VBComponentDim CompItem As Object
Set VBProj = ActiveWorkbook.VBProject
Boolean Dim VBComp As VBIDE.VBComponentname' ===========================================================================
Dim oVBProj As VBIDE.VBProjectDim VBComp As VBIDE.VB
through all references in current database and add them to the newly created dbs
Dim cur_vbRefs As VBIDE.References: Set cur_vbRefs= cur_vbProj.References
Dim cur_vbRef As VBIDE.
Sub Opslaanzonderformules() Dim VBProj As VBIDE.VBProject, VBComp As VBIDE.VBComponent, CodeMod As VBIDE.CodeModule
strFileName = Application.GetSaveAsFilename