Code Compare For VBA Source Code

Question

is there a way to compare VBA source code file, like .IVB file from Autodesk Inventor to another one?

Since this kind of file is precompiled, I have to export every modules from both solutions and compare folders.

But I would prefer to compare source code files directly if I can.

Thanks, best regards.

Compare it to what? If you want to load it, maybe something like this http://forums.autodesk.com/t5/inventor-customization/code-to-load-ivb-files/td-p/4314902 — Slai, Sep 02 '16 at 13:47

score 0 · Answer 1 · answered Sep 05 '16 at 07:27

Instead of exporting each file one at a time, you can use this Sub:

Public Sub Export()
    Dim vbe As vbe
    Set vbe = ThisDrawing.Application.vbe
    Dim comp As VBComponent
    Dim outDir As String
    outDir = "c:\\temp\\VBA"
    If Dir(outDir, vbDirectory) = "" Then
        MkDir outDir
    End If
    For Each comp In vbe.ActiveVBProject.VBComponents
        Select Case comp.Type
            Case vbext_ct_StdModule
                comp.Export outDir & "\" & comp.Name & ".bas"
            Case vbext_ct_Document, vbext_ct_ClassModule
                comp.Export outDir & "\" & comp.Name & ".cls"
            Case vbext_ct_MSForm
                comp.Export outDir & "\" & comp.Name & ".frm"
            Case Else
                comp.Export outDir & "\" & comp.Name
        End Select
    Next comp

     MsgBox "VBA files have been exported to: " & outDir
End Sub

You need to add a reference to Microsoft Visual Basic for Applications Extensibility 5.3.

Actually, to get it to work , I had to replace 3rd line with: `Set vbe = ThisApplication.vbe` — Dounchan, Nov 28 '21 at 21:05

Code Compare For VBA Source Code

1 Answers1