Form Class not supported in VBE/can't be loaded. Can this be converted?

I have a .frm that I am trying to load into VBE. It supplies an error message "The form class contained in [insert location] is not supported in VBE. The file can't be loaded."

Is there some program or tool out there that can 'upgrade' these old .frm formats so that they are compatible?

If I right click and open the .frm with a text editor, I can locate the text dealing with the forms procedures and copy this into a new userform. However all the rest of the text (mostly relating to controls) can't be copied over (compile errors). There is a lot of controls in this file and I don't want to manually add these if there is a converter available.

Hi,

You are trying to load a form from an earlier version of Visual Basic or a form from a current standalone version of Visual Basic. It is probably easiest to redesign the form using the UserForm tools within Visual Basic for Applications. If you can save the form in ASCII format, you may be able to modify the form and import it. However, you must completely understand the formats and limitations of the various form packages.


Regards,
Paresh J

Originally Posted by pareshj

Hi,

You are trying to load a form from an earlier version of Visual Basic or a form from a current standalone version of Visual Basic. It is probably easiest to redesign the form using the UserForm tools within Visual Basic for Applications. If you can save the form in ASCII format, you may be able to modify the form and import it. However, you must completely understand the formats and limitations of the various form packages.


Regards,
Paresh J

That's exactly what Microsoft said ( http://msdn.microsoft.com/en-us/libr...ffice.15).aspx ) - which I googled before I started this thread.


1. I don't know what the form originally looked like so I can't redesign it.
2. I don't know how to modify the .frm to allow it to import.

Hi,

What you can do is try to recover your .frm in VB IDE and then try to redesign it in VBA.


Regards,
Paresh J

Originally Posted by pareshj

try to recover your .frm in VB IDE

How do I do that? I don't think I have a VB IDE installed.

Hi,

You can only recover this in VB IDE. You need to install this or check for any third party tool online which can do the same.

Regards,
Paresh J

Attached is the .frm I'm trying to convert.

As per the OP, if anyone knows of a conversion tool/code that can convert this, I'd be very interested.

Open the file in notepad. You should be able to recreate the useform from the details contained within.

I have already used a text editor to open the frm file and copy/paste the macro code to a new form. However this doesn't work for controls.

As started in the OP, worse case scenario I can always use this information to manually set up the controls in the new form. However this is a rather tedious process so if there is any conversion tool available it would save me time and effort.

I'm pretty sure you could have done it in the week this question has been going.

FWIW I've never heard of such a tool.

Originally Posted by romperstomper

I'm pretty sure you could have done it in the week this question has been going.

I'm sure I could have If I hadn't been beavering away on other projects at the time!

Originally Posted by romperstomper

FWIW I've never heard of such a tool.

That makes two MVPs who haven't heard of a converter. I sadly accept that such a thing most likely doesn't exist and I suppose that it wouldn't be easy creating something in VBA to convert an outdated .frm file so I will mark this thread SOLVED.


If anyone reading this in future knows of such a tool, please post and let us know!