i dont think u can run Excel Macro thru online

last time i remember even thru own MS sharepoint also cannot run these legacy macro code when open excel file directly on browser

u need to convert it to work with other like PowerBI


if your main goal is re-using existing and working Excel Macro with 0 code modification ; i think just get 1 VMWare or server that have more cores + 64 bit MS office pre-installed.. trigger it on specific time thru some automation tool or even by another vba script + task scheduler to refresh your excel data.

This post has been edited by fantasy1989: Oct 22 2022, 11:20 PM