![]() It requires additional configuration and overhead. JavaScript is also viable but do not expect the same experience you had with VBA. Power Automate makes it relatively easy to extend automation across office apps and beyond the range of simple recorded macros. Users of the VBA macro recorder may even feel right at home using it with Excel's new macro recorder in the Automate tab of the ribbon. Office Scripts is likely the easiest entry point to begin automating simple routine tasks. Microsoft's documentation goes as far as saying the web apps cannot create, edit, or run VBA.Īt the minimum, Office for the web supports automation with Office Scripts, Power Automate, and Java Script. They can open VBA enabled documents but the VBA components are hidden. Apps in this version of office do not have the VBA IDE and will not load VBA project modules. ![]() Microsoft Office for the web does not support VBA.
0 Comments
Leave a Reply. |