Tag: VBA
-
What VBA Is: Limits, Future Outlook, When to Replace It, and Practical Migration Patterns
A practical guide to what VBA is, its limits, where replacement makes sense, and how to migrate existing Excel or Access assets in stages.
-
How to Use a .NET 8 DLL from VBA with Early Binding via COM and dscom
A practical guide to exposing a .NET 8 class library through COM, generating a type library with dscom, and using it from VBA with early binding instead of l...