Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- Sub ExportCode()
- Dim app As Excel.Application
- Set app = New Excel.Application
- Dim wb As Excel.Workbook
- Set wb = Excel.Application.Workbooks.Open("C:Book2.xls")
- Dim strExt As String
- Dim VBComp As Object
- For Each VBComp In wb.VBProject.VBComponents
- Select Case VBComp.Type
- Case 2 ' Class module
- strExt = ".cls"
- Case 3 ' Form
- strExt = ".frm"
- Case 1 ' Standard module
- strExt = ".bas"
- Case 100 ' Document?
- strExt = ".cls"
- Case Else
- Stop ' What else is there?
- strExt = ".cls"
- End Select
- VBComp.Export "C:" & VBComp.Name & strExt
- Next
- wb.Close False
- app.Quit
- End Sub
Add Comment
Please, Sign In to add comment