Malwarebytes disables VBScripts from running in MS Office. We show you how to fix that in this post as we work through an example in Excel. 3 minutes is all it takes! Read More
C#, Excel, and SQL Server
Using Excel to work with SQL Server data sets is often more convenient than having to write a complete solution using C#. A variety of solutions exist to work with Excel from your C# code and Microsoft.Office.Interop.Excel is just one of them. EPPlus is also a popular solution for working with Excel. EPPlus is free… Read More
How to Create Excel Files in C#
How to Create and Read Excel files from your C# application. Read More
Why is Excel crashing when loading Macro-Based workbooks?
.NET 5 and VBA may cause Excel to Crash, Vanish, or Disappear from your screen. Visual Studio 2019 may be the reason why .NET 5 is now your active .NET runtime. Read More