Thread: [Solved] Copy the Code from an Excel Form to a Worksheet automatically
View Single Post
 
Old 10-19-2023, 01:41 PM
Logit Logit is offline Windows 10 Office 2007
Expert
  
Join Date: Jan 2017
Posts: 587
Logit is a jewel in the roughLogit is a jewel in the roughLogit is a jewel in the roughLogit is a jewel in the rough
Default
Quote:
Must be somewhere in the VBComponent.Export bit I guess?
Did a little internet research and I agree with your assumption. Trust we are both correct on this. Seems if you move a .frm file to another project the .frx file must go with it as it is part of the entire .frm makeup.

One website states :
Quote:
When we export forms from VBA projects it creates two files of two different types. One file with .frm extension and another with the .frx extension. .frm file contains the codes of the form. The .frx file includes the elements of the form file. Especially the graphical elements.
Reply With Quote