Articles Tagged “Excel”
9 articles tagged “Excel”, newest first.
-
Automating Data Entry Into Legacy Core Systems With Power Automate for Desktop — Replacing Manual Entry From Excel and Paper With UI Automation
A practical guide to replacing manual data entry into old core systems that have no API, using UI automation in Power Automate for desktop (PAD). Covers what...
-
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...
-
Should Contracted Development Specs Stay in Excel? — Choosing the Right Format for Deliverables
Should the specification and design documents delivered in contracted development stay in Excel 'graph paper' format? This article works through the problems...
-
CSV Is Not "Just Text": A Practical Guide to CSV Handling in C# Business Apps (Encoding, Excel Compatibility, Injection Defense)
A practical rundown of the classic failure patterns in business-app CSV I/O - hand-rolled Split(',') parsing, mojibake from BOM-less UTF-8 in Excel, lost lea...
-
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...
-
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...