}
| If you want to... | Use... | |-------------------|---------| | Insert custom UI into Word/Excel | Office Add-in (JS) | | Automate Excel without deploying a server | Office Scripts | | Read/write emails, calendars, or Teams messages | Microsoft Graph API | | Build a SharePoint dashboard | SPFx | | Automate a legacy on-premises macro | VBA (but plan to migrate) | code microsoft office 365
The concept of a "code" in Microsoft Office 365 typically refers to two distinct areas: the used for activation and the extensibility of the suite through programming languages like VBA, Office Scripts, and the Office JavaScript API. The Activation Mechanism: Product Keys } | If you want to
// This code inserts "Hello World" into the active cell Office.onReady(() => document.getElementById("runButton").onclick = () => Excel.run(async (context) => const sheet = context.workbook.worksheets.getActiveWorksheet(); const range = sheet.getRange("A1"); range.values = [["Hello World from Office Add-in"]]; await context.sync(); ); ; ); The Activation Mechanism: Product Keys // This code
The Graph API is the gateway to across Office 365.
This bridges the gap between the old world of desktop macros and the new world of cloud automation.