 | ||||||
FRX files
Can Do
![Goto Guest book sign in page [Home]](files/guestbook.gif)
Thanks for visiting my site lucky visitor:
This page was last updated on: March 22, 2009
Copyright © 2002. XcelFiles. All Rights Reserved Ivan F Moala
What is an FRX file, it is a binary file belonging to VBA .FRM (form stash file) file. When you export out a userform, this file is created. FRX files are binary data files originally designed for the storage of form properties that could not be saved in text format, eg icons & bitmaps etc.
VBA like Visual Basic stores binary information in the FRX files. For example, if you set a form's Picture property at design time, VBA stores the image in this file.
VBA will create an .frx file when certain properties of a userform are set. (One of these is the picture property). The frx binary file must accompany the program if you ever export out your userforms and import them to another project
If your still not sure what these files are then while in the VBA Editor > Explorer right click on a Userform and export the form. Now in your Explorer application view the directory with the Userform.frm file. You will see another file with the same name BUT with an frx extension. This is the file that contains your icons, images etc.
When VBA exports a form, it arranges the properties in a default ordering. However, you can list properties in any order when creating a form.
Any property you don’t list is set to its default value when imported. When VBA exports a userform, it includes only those properties that do not use default values as their settings. Each control determines whether or not all of its properties are saved, or only those whose values are different from the default settings.
Binary Property Values
Some controls have properties that have binary data as their values, such as the Picture property of picture box and image controls or certain properties of custom controls. Visual Basic saves all binary data for a form in a binary data file separate from the form.
VBA saves the binary data file in the same directory as the userform. The binary data file has the same file name as the form, but it has an .frx filename extension. VBA reads the binary data file when importing the form. The binary data file (.frx) must be available to the form when VBA imports it. If you share forms with others that use a binary data file, be sure to provide the binary data file (.frx) as well as the userform (.frm).
In VBA only the OleObjectBlob is referenced for the frx offset. For example,
VERSION 5.00
Begin {C62A69F0-16DC-11CE-9E98-00AA00574A4F} UserForm2
Caption = "UserForm2"
ClientHeight = 3510
ClientLeft = 45
ClientTop = 435
ClientWidth = 4710
OleObjectBlob = "testfrm.frx":0000
StartUpPosition = 1 'CenterOwner
End
Note the CLSID = C62A69F0-16DC-11CE-9E98-00AA00574A4F
= Microsoft Forms 2.0 Form
The property listing means that the binary data that defines the oleobjectBlob of this userform begins at byte 0000 (hex) in the file UserForm2.frx. In fact this is always the case for offsets with VBA Userforms. For VB it is defined differently.
Frx Userform;
Please NOTE:
1) In some instances a BMP file will not display properly, I know why and how to fix this, but have left this out...... see if you can work it out :-)
2) This will also work on frx files from VB forms.
