|
发表于 2010-12-31 04:14
|
显示全部楼层
本楼为最佳答案
本帖最后由 Dj_soo 于 2010-12-31 11:05 编辑
先要引用 MICROSOFT VISUAL BASIC FOR APPLICATION EXTENSIBLITY
- Sub Test()
- Dim Mdl As VBComponent
- Dim Line As Long
- Dim i As Long
- Dim Col As Integer
- Dim SubName As String
- Dim arr As Variant
- For Each Mdl In ThisWorkbook.VBProject.VBComponents
- With Mdl.CodeModule
- For i = 1 To .CountOfLines
- SubName = .ProcOfLine(i, vbext_pk_Proc)
- If SubName <> "" Then
- Col = Col + 1
- Line = .ProcCountLines(SubName, vbext_pk_Proc)
- arr = Split(.Lines(i, Line), vbCrLf)
- arr(0) = Mdl.Name
- Cells(1, Col).Resize(Line) = Application.Transpose(arr)
- i = i + .ProcCountLines(SubName, vbext_pk_Proc) - 1
- End If
- Next i
- End With
- Next
- Columns.AutoFit
- End Sub
复制代码 |
评分
-
查看全部评分
|