Category Archives: .Net

My First Custom Ribbon Using Excel-DNA And Visual Studio

For the next instalment in this “getting started with Excel-DNA for VBA’ers ” mini-series I’m going to have a look at customisation of the Office ribbon. The end goal of this post is very simple: a custom tab with a button which shows … Continue reading

Posted in Excel-DNA, Microsoft Excel, Visual C# | Tagged , , | 3 Comments

My First C#.Net UDF Using Excel-DNA And Visual Studio

Having recently blogged about the importance of broadening my programming horizon, I felt it was high time I put together a step-by-step guide on how to create an Excel UDF in Visual Studio using Excel-DNA. In this post I’m specifically targeting … Continue reading

Posted in Excel-DNA, Microsoft Excel, Visual C# | Tagged , , , , | 6 Comments

Excel Development Roadmap – Where Next?

The developer tool suite offered by Microsoft for Excel is currently a set of three complimentary technologies: Visual Studio Tools for Office (Dot Net) Apps for Office (Javascript) Visual Basic For Applications The VBA language is an interesting one. Often referred to … Continue reading

Posted in .Net, Microsoft Excel, Visual C# | Tagged , , , | 6 Comments

Who Has My Workbook Open? [C#.Net]

I had to update a C# project this week so it can check if someone has opened (and locked) an Excel workbook. Identifying the actual culprit is surprisingly hard to do – there’s nothing useful in the Excel object model itself … Continue reading

Posted in Microsoft Excel, Visual C# | 1 Comment

Enforcing Mutex On A SQL Server Database – Part 2

In May I wrote about how application-level mutual exclusivity could easily be implemented on SQL Server by using sp_getapplock and sp_releaseapplock: sp_getapplock tries to get a lock and returns one of a possible set of values which indicate various forms … Continue reading

Posted in .Net, Microsoft SQL Server, Visual C# | Tagged , , , | Leave a comment

Enforcing Mutex On A SQL Server Database

I’ve been working on a project which involved several different components. These components had the potential to interact with a SQL Server database at the same time and  I had to come up with a way of ensuring that each … Continue reading

Posted in Microsoft SQL Server, Visual C# | Tagged , , | 3 Comments

Online .NET Regex Tester

In a recent project at work I had to learn the basics of the .NET System.Text.RegularExpressions namespace. Regular expressions in .NET are far more complete (and daunting) than the Microsoft VBScript Regular Expressions library I occasionally use in VBA. Fortunately for me, I sit next to an … Continue reading

Posted in .Net | Tagged , | 2 Comments

A Common Mistake When Declaring Variables In VBA

For today’s post I’d like you to imagine that you’re an up and coming VBA programmer who is starting to feel at home with the IDE and language. You’ve read about some VBA best practices which has made you aware of the … Continue reading

Posted in .Net, Microsoft Excel, Microsoft Office, VB .Net | Tagged , , , , , , | 10 Comments