Export Custom Form, .frx .frm files

[Neal Zimm]

Just exported my first custom form into another workbook.

Imported the xxxxxxx.frm file and form worked.

Got error msg that xxxxxxxx.frx file could not be imported.

What is .frx and how important is it ?

Thanks.

 

[Jacob Skaria]

Refer the below

http://support.microsoft.com/kb/152582

http://www.xcelfiles.com/FRX.html

If this post helps click Yes

 

[Dave Peterson]

When I'm doing the (manually using the VBE interface), I'll just open both
workbooks and then go to the VBE.

Then I'll find the userform to copy in the source workbook project and drag it
to the receiving workbook project (in the project explorer window (ctrl-r if you
don't see it).

 

[Chip Pearson]

The frm file is basically the code module that contains the VBA code
associated with your userform. The frx file is a binary file that
contains the (descriptions of) the form itself, all the controls that
reside on the form, and other resources needed to create the form. VBA
expects that the frm and the frx files have the same name (the name of
the userform) and that they reside in the same directory. You can open
both the frm and frx files in Notepad or your favorite text editor to
see what's in them. The frm file is readable, and it just has the VBA
code (and a few directives) that you'd see in the VBA editor. The frx
file is binary and contains nothing that you can read.

how important is it ?

Critically important. Without the frx file, there is no form.

Cordially,
Chip Pearson
Microsoft Most Valuable Professional
Excel Product Group
Pearson Software Consulting, LLC
www.cpearson.com
(email on web site)

 

[Neal Zimm]

Thanks. Clears it up.
--
Neal Z

Refer the below

http://support.microsoft.com/kb/152582

http://www.xcelfiles.com/FRX.html

If this post helps click Yes

 

[Neal Zimm]

Thanks Chip, I'll use the drag 'n drop method from now on.

To follow up, when I imported the .frm file (it and .frx were exported to
desktop) did Exel import the .frx file without my knowing it ? (hence the
error msg when trying to import .frx individually)

Thanks again,