Articles Tagged “Office”
9 articles tagged “Office”, newest first.
-
Automating Purchase-Order and Invoice PDFs That Arrive by Email With Power Automate — Designing Storage, Routing, Notification, and Extraction
A practical guide to automating the storage, routing, and notification of purchase-order and invoice PDFs that arrive by email with Power Automate, covering ...
-
Migrating Excel VBA Macros to Power Automate — What to Replace with Office Scripts, and What to Leave as VBA
A guide to whether Excel VBA macros can migrate to Power Automate, covering what Office Scripts can replace, what only VBA can still do, connector limits, li...
-
Why EXCEL.EXE Processes Remain After C# Excel COM Automation — Reference Release Patterns and the Replacement Decision
A practical look at why EXCEL.EXE processes remain running after automating Excel from C# via Microsoft.Office.Interop.Excel, explained through COM reference...
-
Automating Business Processes with Power Automate — Cloud Flows, Desktop Flows, and Robust Error Handling
A practical design guide to Power Automate: the difference between cloud flows and desktop flows, when to use PowerShell or VBA instead, licensing, error han...
-
Why ActiveX Stops Working in Office 2024/Microsoft 365 and How to Diagnose It
When ActiveX stops working in Office 2024/Microsoft 365, work through the causes in order: default disablement, 32-bit/64-bit mismatch, COM registration, dep...
-
Preparing for VBScript Deprecation: An Audit Guide for VBA and Internal Tools
Preparing for the phased deprecation of VBScript: inventorying VBA, Excel macros, and internal tools, static detection, execution logging, choosing replaceme...
-
What Is VBA? - Its Constraints, Its Future, When to Replace It, and Realistic Migration Patterns
VBA isn't dying, but its role has narrowed. When to keep Excel macros, and when to move logic to .NET, Office Scripts, or Add-ins - with migration patterns.
-
How to Build Excel Report Output - COM / Open XML / Templates
The design of Excel report output changes considerably depending on whether you automate Excel itself, generate xlsx files directly, or keep existing VBA. As...
-
Using a .NET 8 DLL from VBA with Full Typing - COM Exposure and dscom TLB
Call .NET 8 code from VBA with early binding: expose a class library to COM, generate a TLB with dscom, and register the comhost DLL. Sample code on GitHub.