Export Custom Form, .frx .frm files
 

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)



On Sat, 20 Jun 2009 23:16:01 -0700, Neal Zimm
wrote:

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.

Export Custom Form, .frx .frm files
 

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,

--
Neal Z


"Chip Pearson" wrote:

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)



On Sat, 20 Jun 2009 23:16:01 -0700, Neal Zimm
wrote:

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.