Articles by PRAGMATEEK

Extend your VBA code with C#, VB.NET, or C++/CLI

By Pragmateek

Interfacing VBA and .NET is a relatively straightforward process.

JSON vs. XML: Some hard numbers about verbosity

By Pragmateek

I've written a small Java benchmark that I'll present, along with its results, in this article.

Java/JSON mapping with Gson

By Pragmateek

Java/JSON mapping with Gson.

Using an Access, MySQL, PostgreSQL or SQLite database from VBA

By Pragmateek

[toc] Introduction Note to pedantic guys: yes Access is not a database engine, only the graphical front-end to Jet/ACE, but we’ll stand with this simplification. The sample application (Excel + VBA) and the SQL source code are available in this …...

C#: Scope Your Global State Changes with IDisposable and the Using Statement

By Pragmateek

How to scope your global state changes with IDisposable and the using statement

“If all you have is a hammer…

By Pragmateek

…everything looks like a nail” says the proverb. I’ll illustrate it with a little story about a common mistake I see sometimes. (Code samples are in C# but use only basic features so C++ and Java developers should not be … Continue reading...

Excel UDF library in C# from scratch

By Pragmateek

Introduction In this article I’ll show you how to create a UDF library for Excel in C# from scratch. By “from scratch” I mean without using Visual Studio, only low-level tools : a simple text-editor like Notepad and the C# … Continue...