Copy the Code from an Excel Form to a Worksheet automatically

Logit · #5 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.

???

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Link UserForm checkbox to corresponding shape on one worksheet and copy to 'template' worksheet	kiwimtnbkr	Excel Programming	23	10-08-2020 02:32 AM
Need to copy specific ranges column data as row data from one worksheet to another using excel VBA	ganesang	Excel Programming	1	03-26-2020 06:18 AM
How to get Excel to automatically continue a pattern which is form as 001-01-01 ....003-03-03	anakonda93	Excel	3	04-16-2018 12:01 AM
Automatically copy/paste a form field onto new pages, with user input included	Pindar	Word VBA	3	01-13-2017 11:49 AM
VB Code in Excel Active worksheet	shakilhyd	Excel	2	05-17-2010 07:50 AM