Forum Discussion
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 m...
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.