Thread: [Solved] Copy the Code from an Excel Form to a Worksheet automatically
View Single Post
 
Old 10-19-2023, 10:12 AM
MC147 MC147 is offline Windows 10 Office 2021
Advanced Beginner
  
Join Date: Feb 2022
Posts: 50
MC147 is on a distinguished road
Default
A follow up question on this that I can't figure out.
I changed the extension of Form to .txt as that is all I am interested in, and change the code to read :-
If extension = ".txt" Then
path = directory & "" & VBComponent.Name & extension
Call VBComponent.Export(path)
......

However, it still insists on producing an .frx file as well as a .txt file in the Visual Basic directory. Can't see how it is doing it. Must be somewhere in the VBComponent.Export bit I guess?
Reply With Quote