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