Microsoft Office Forums - View Single Post - [Solved] Copy the Code from an Excel Form to a Worksheet automatically

Logit · 10-19-2023, 10:28 AM

Is this the section where you changed .frm to .txt ?

Code:

For Each VBComponent In ActiveWorkbook.VBProject.VBComponents
        Select Case VBComponent.Type
            Case ClassModule, Document
                extension = ".cls"
            Case Form
                extension = ".frm"
            Case Module
                extension = ".bas"
            Case Else
                extension = ".txt"
        End Select

The code already had a selection for .txt.

???