Forum Discussion

giampaolo67's avatar
giampaolo67
Copper Contributor
Oct 21, 2021

call api from activeX

Hello

I wrote some VBA code invoked by a control in excel desktop

when i try to open this file from excel office365 it says 

how can I replace the component in excel 365 to continue to use my files?

thank you

Giampaolo 

1 Reply

  • an_an's avatar
    an_an
    Copper Contributor

    Excel on the web (Office 365) doesn’t support ActiveX controls or VBA macros. That’s why you see those warnings, those components only work in the desktop version of Excel for Windows.

    If you want something that also runs in Excel for the web, you’d need to replace your ActiveX/VBA solution with either:

    Office Scripts (runs in Excel for the web, focused on automation), or

    An Office Add-in built with the JavaScript API (cross-platform, works in desktop and web).

    Unfortunately, there isn’t a way to make ActiveX controls work in Excel 365 online. The only workaround is to continue opening the file in the desktop app, or rebuild the solution using the newer APIs that are supported in both web and desktop.

Resources