Category Archives: Visual C#

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