How to i migrate my macros to officescript for microsoft excel?

Question

We would like to request assistance in converting existing Excel VBA macros into Office Scripts for improved automation compatibility within Microsoft 365 (Excel for the web).

Details of the Request:

• Current Setup: We are using an Excel template that relies on:
  • VBA macros
    • ActiveX controls (forms/buttons)
    • Template Location: NarrowCast Templet\NarrowCast Templet\BRM\BRM LYC TO LY\PRODUCTION LYC to LY

Key Challenge:

• ActiveX controls are not supported in Excel for the web / Office Scripts
• Due to this limitation, the current macro-based workflow cannot be migrated directly Requirement: We want to:
• Convert all existing VBA macros in this template into Office Scripts
• Ensure the solution works seamlessly in Excel Online
• Maintain the same business logic and outputs currently achieved through macros
  • Improve maintainability and enable integration with Power Automate if applicableWe would like to request assistance in converting existing Excel VBA macros into Office Scripts for improved automation compatibility within Microsoft 365 (Excel for the web).

    Details of the Request:

    • Current Setup:
      We are using an Excel template that relies on:
      • VBA macros
      • ActiveX controls (forms/buttons)
    • Template Location:
      NarrowCast Templet\NarrowCast Templet\BRM\BRM LYC TO LY\PRODUCTION LYC to LY

    Key Challenge:

    • ActiveX controls are not supported in Excel for the web / Office Scripts
    • Due to this limitation, the current macro-based workflow cannot be migrated directly
    Requirement:
    We want to:
    • Convert all existing VBA macros in this template into Office Scripts
    • Ensure the solution works seamlessly in Excel Online
    • Maintain the same business logic and outputs currently achieved through macros
    • Improve maintainability and enable integration with Power Automate if applicable

Answer 1

Dear @Kundu, Iyoshi,

I hope you’re having a good day. 

Thank you for providing the details of your requirement.

Based on your description, the current solution relies heavily on VBA macros and ActiveX controls, which are not supported in Excel for the web. While many VBA-based automation scenarios can potentially be rewritten using Office Scripts, there is currently no automatic migration tool that can convert an entire VBA/ActiveX solution into Office Scripts. In addition, ActiveX controls, UserForms, workbook events, and other legacy components often require redesign rather than direct conversion.

To determine whether the existing functionality can be migrated and what approach should be used (Office Scripts, Power Automate, Power Apps, or Office Add-ins), the actual workbook and VBA code would need to be reviewed in detail. Without access to the workbook and the underlying code, it is not possible to accurately assess the required effort or provide a complete conversion solution.

Therefore, I recommend opening a Microsoft Support ticket so that the support team can review your specific workbook, understand the business requirements, and provide more targeted guidance on a supported modernization path.

You can create a support request through the Microsoft 365 Admin Center>Support>Help & Support.  

For reference:  Get support | Microsoft Docs   

Please understand that, as a community member, I do not have access to your workbook, VBA source code, or tenant environment, and therefore cannot perform or validate the migration myself.

I hope this points you in the right direction. If you need any further assistance or have additional questions, please don’t hesitate to reach out. I'm here to help. 

Best regards, and good luck with your modernization project!

---

If the answer is helpful, please select "Yes" and kindly upvote it. If you have extra questions about this answer, please click "Comment".  

Note: Please follow the steps in the forum documentation to enable email notifications if you want to receive the related email notification for this thread.