Articles Tagged “VBA”
6 articles tagged “VBA”, newest first.
-
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...
-
Extending the Life of and Migrating VB6 / Access Business Apps — A Decision Table for Keep, Wrap, or Replace
How do you decide whether to leave a VB6 application or Microsoft Access business app as-is, extend its life by wrapping only part of it, or replace it outri...
-
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.
-
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.