code_junkie

To Extract/Display Macro (VBA) from .xls files using VB6 (without openning Excel)

Nov 13th, 2011
158
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.67 KB | None | 0 0
  1. Sub ExportCode()
  2. Dim app As Excel.Application
  3. Set app = New Excel.Application
  4.  
  5. Dim wb As Excel.Workbook
  6. Set wb = Excel.Application.Workbooks.Open("C:Book2.xls")
  7.  
  8. Dim strExt As String
  9.  
  10. Dim VBComp As Object
  11. For Each VBComp In wb.VBProject.VBComponents
  12. Select Case VBComp.Type
  13. Case 2 ' Class module
  14. strExt = ".cls"
  15. Case 3 ' Form
  16. strExt = ".frm"
  17. Case 1 ' Standard module
  18. strExt = ".bas"
  19. Case 100 ' Document?
  20. strExt = ".cls"
  21. Case Else
  22. Stop ' What else is there?
  23. strExt = ".cls"
  24. End Select
  25.  
  26. VBComp.Export "C:" & VBComp.Name & strExt
  27. Next
  28. wb.Close False
  29. app.Quit
  30.  
  31. End Sub
Add Comment
Please, Sign In to add comment