none
Cannot open old .xla file in Excel 2016 RRS feed

  • Question

  • Hi All!

    I have problem with opening old .xla file containing VBA code in Excel 2016. I am getting following message: 

    "Opening the VBA project in this file requires a component that is not currently installed. This file will be opened without the VBA project. For more information, search Microsoft Office Online for "VBA converters."

    Is there any workaround for that problem.

    Thanks!

    Ivan Ratkovcic

    Wednesday, July 17, 2019 8:40 AM

All replies

  • Hi,

    Excel 2007 and newer version do not directly support the conversion of macros that are written by using Excel 5.0/95 VBA. The old .xla file you are trying to open contains macros that are written on Excel 5.0/95 module sheets. The Office 2016 cannot write the Excel 5.0/95 module sheet format, and then you may receive the error message.

    You can refer this document : https://support.microsoft.com/en-us/help/926430/you-are-requested-to-search-microsoft-office-online-for-vba-converters

    Hope it's helpful.

    Regards,

    Emi Zhang


    Please remember to mark the replies as answers if they helped. If you have feedback for TechNet Subscriber Support, contact tnsf@microsoft.com.

    Click here to learn more. Visit the dedicated forum to share, explore and talk to experts about Microsoft Office 2019.

    Thursday, July 18, 2019 6:38 AM
    Moderator
  • Hi, 

    Just checking in to see if the information was helpful. Please let us know if you would like further assistance.

    Regards,

    Emi Zhang


    Please remember to mark the replies as answers if they helped. If you have feedback for TechNet Subscriber Support, contact tnsf@microsoft.com.

    Click here to learn more. Visit the dedicated forum to share, explore and talk to experts about Microsoft Office 2019.

    Wednesday, July 24, 2019 9:18 AM
    Moderator
  • Hi,

    I'm seeing the same error when opening an excel 95 format file that has macros (vba). The document referenced above talks about installing a VBA converter pack but the link to install states the hotfix is unavailable and to install Windows 10. I have Windows 10 and am still getting the error.

    Saturday, August 31, 2019 12:10 AM
  • I'm not a tech, but AskWoody has been detailing problems in VBA caused by the August updates in all versions of Windows from 7 up.

    You might look at www.askwoody.com .


    glnzglnz
    ☺ In the office, Dell Optiplex 7040 with 8GB RAM, Win 7 Pro 64-bit and Office 2010
    ☻ At home, Dell Optiplex 7010 with 16GB RAM dual-booting Win 7 Pro 64-bit (now with Office 365 Home) and Win 10 Pro 64-bit
    ♥ Also still have Dell Optiplex 755 with 4GB RAM with Win XP Pro SP3 (which got updates through April 2019 with the POS hack) and Office 2003

    Saturday, August 31, 2019 12:59 PM