+ Reply to Thread
Results 1 to 12 of 12

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

  1. #1
    Valued Forum Contributor
    Join Date
    08-29-2012
    Location
    In lockdown
    MS-Off Ver
    Excel 2010 (2003 to 2016 but 2010 for choice)
    Posts
    1,766

    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.
    *******************************************************

    HELP WANTED! (Links to Forum threads)
    Trying to create reusable code for Custom Events at Workbook (not Application) level

    *******************************************************

  2. #2
    Forum Contributor pareshj's Avatar
    Join Date
    05-20-2014
    Location
    MUMBAI
    MS-Off Ver
    2007 & 2010
    Posts
    447

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

    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
    Click on "* Add Reputation" as a way to say thanks

  3. #3
    Valued Forum Contributor
    Join Date
    08-29-2012
    Location
    In lockdown
    MS-Off Ver
    Excel 2010 (2003 to 2016 but 2010 for choice)
    Posts
    1,766

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

    Quote Originally Posted by pareshj View Post
    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.

  4. #4
    Forum Contributor pareshj's Avatar
    Join Date
    05-20-2014
    Location
    MUMBAI
    MS-Off Ver
    2007 & 2010
    Posts
    447

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

    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

  5. #5
    Valued Forum Contributor
    Join Date
    08-29-2012
    Location
    In lockdown
    MS-Off Ver
    Excel 2010 (2003 to 2016 but 2010 for choice)
    Posts
    1,766

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

    Quote Originally Posted by pareshj View Post
    try to recover your .frm in VB IDE
    How do I do that? I don't think I have a VB IDE installed.

  6. #6
    Forum Contributor pareshj's Avatar
    Join Date
    05-20-2014
    Location
    MUMBAI
    MS-Off Ver
    2007 & 2010
    Posts
    447

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

    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

  7. #7
    Valued Forum Contributor
    Join Date
    08-29-2012
    Location
    In lockdown
    MS-Off Ver
    Excel 2010 (2003 to 2016 but 2010 for choice)
    Posts
    1,766

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

    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.
    Attached Files Attached Files

  8. #8
    Forum Guru Andy Pope's Avatar
    Join Date
    05-10-2004
    Location
    Essex, UK
    MS-Off Ver
    O365
    Posts
    19,945

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

    Open the file in notepad. You should be able to recreate the useform from the details contained within.
    Cheers
    Andy
    www.andypope.info

  9. #9
    Valued Forum Contributor
    Join Date
    08-29-2012
    Location
    In lockdown
    MS-Off Ver
    Excel 2010 (2003 to 2016 but 2010 for choice)
    Posts
    1,766

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

    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.

  10. #10
    Forum Guru romperstomper's Avatar
    Join Date
    11-04-2008
    Location
    A1
    MS-Off Ver
    Most
    Posts
    12,302

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

    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.
    Remember what the dormouse said
    Feed your head

  11. #11
    Valued Forum Contributor
    Join Date
    08-29-2012
    Location
    In lockdown
    MS-Off Ver
    Excel 2010 (2003 to 2016 but 2010 for choice)
    Posts
    1,766

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

    Quote Originally Posted by romperstomper View Post
    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!

    Quote Originally Posted by romperstomper View Post
    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!

  12. #12
    Forum Guru Kyle123's Avatar
    Join Date
    03-10-2010
    Location
    Leeds
    MS-Off Ver
    2016 Win10
    Posts
    7,186

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

    Why don't you just write one? As long as you aren't using any exotic controls it shouldn't be particularly difficult - it's only text parsing, you should be able to get 90% of the way there - you've done far more obscure and difficult things in the past.

    If you want a hint to reduce the code required, have a look at CallByName

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Class Newbie question #2 - Check if Class already loaded/set?
    By mc84excel in forum Excel Programming / VBA / Macros
    Replies: 11
    Last Post: 04-16-2014, 06:59 PM
  2. Data to be converted in vertical form populating unique values
    By kapilkarap@gmail.com in forum Excel General
    Replies: 2
    Last Post: 04-16-2014, 08:10 AM
  3. Checking for User Form loaded
    By scottintexas in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 07-21-2008, 02:58 AM
  4. Event when a user form is loaded
    By shashi1515 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 03-28-2006, 04:34 PM
  5. [SOLVED] How check if form is loaded?
    By Jos Vens in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 01-28-2005, 09:06 AM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1