Browse by Tags

Time to move on – Exit MVP Program

Around 2005 – 2006 I peaked with MS Excel, since then I have slightly moved away from it year to year. In 2010 I was honored to become part of Microsoft’s MVP-program. Of course, it was interesting to get another position and more closed to Microsoft in general, the production team in particularly. However, I never [...] Read More...

Published Sun, Apr 04 2013 10:27 AM by VSTO & .NET & Excel

Filed under: COM Add-ins, .NET Books, VSTO Books, .NET & Excel, VSTO & Excel, SQL Server, Excel, XLLs, Apps for Office

Combinatorics Using Excel Formulas

I have the honor to know Roberto Mensa via Linked In. He is strongly committed to explore, develop, improve and to discuss formulas in Excel. The site is fully dedicated to Excel formulas. Of course, he is not alone. There are some other people that make very good contributions too. He has named his virtual [...] Read More...

Published Thu, Mar 03 2013 2:45 PM by VSTO & .NET & Excel

Filed under: COM Add-ins, .NET & Excel, Excel, XLLs

Office Developer Tools for Visual Studio 2012

Great news! Microsoft have announced today that the RTM version of Office Developer Tools for Visual Studio 2012 has been launched. For more information please read the following entry at Somasegar’s blog: Now Available: Office Developer Tools for Visual Studio 2012 Enjoy! Kind regards, Dennis Read More...

Published Mon, Mar 03 2013 4:29 PM by VSTO & .NET & Excel

Filed under: .NET & Excel, SharePoint, VSTO & Excel, Excel, XLLs, Valentina DB, Valentina Office Server, Database

POEditor: An Excellent Translation Tool!

It’s very exceptionable that I get thrilled over a software. The last time must be the first version of Excel 2.1d, that’s nearly 30 ago, I got in my hand! I can only say that it’s an excellent software and it’s also free. It’s so good that I say its speak for itself. The URL to POEditor [...] Read More...

Published Fri, Feb 02 2013 10:27 AM by VSTO & .NET & Excel

Filed under: COM Add-ins, Tools, .NET & Excel, VSTO & Excel, UI Design, SQL Server, Excel, XLLs, Installation Tools, Valentina DB, Valentina Office Server, Apps for Office, Database, Spreadsheet components, VMWare

Tools for MS Excel 2013 Development

I just want to add an article that gives the URLs for downloading the SDK and the Toolkit for Apps for Office with Visual Studio 2012. It’s not easy to keep up the pace and find the required tools so this is also a reminder to myself. Download: Excel 2013 SDK: Excel 2013 XLL Software [...] Read More...

Published Fri, Dec 12 2012 7:12 AM by VSTO & .NET & Excel

Filed under: Tools, .NET & Excel, VSTO & Excel, Excel, XLLs, Apps for Office

Axialis Pure Flat 2013 Toolbar Stock Icons Rock!

A software program’s success is usually depended on its functionality, i.e. it does the work and it has a user-friendly UI. In fact, the UI is the most important part of applications as that is what the end-users see and work via. This is something we all known (or at least should know). Among the [...] Read More...

Published Fri, Nov 11 2012 7:00 PM by VSTO & .NET & Excel

Filed under: COM Add-ins, Tools, .NET & Excel, VSTO & Excel, UI Design, Excel, XLLs, Real Basic Developing

VLOOKUP Week; Using VLOOKUP in VB

Bill Jelen, MrExcel, has marked this week to honor the VLOOKUP function in MS Excel. Around the online Excel development community You will find contributions, usually blog posts, that gives various aspects for using or not VLOOKUP. I thought it would be interesting to create a case and see how VLOOKUP can be part of [...] Read More...

Published Thu, Mar 03 2012 9:49 AM by VSTO & .NET & Excel

Filed under: COM Add-ins, .NET & Excel, VSTO & Excel, Excel, XLLs

From VBA to VB.NET using ExcelDna

This is a notification about a recent published article by Patrick O’Beirne on his blog. Patrick has compiled a list of resources, for native Excel developers, to develop User Defined Functions (UDFs) with ExcelDna in VB.NET. For some years ago several developers in the online Excel community made quite often critical comments and rant a lot about using .NET [...] Read More...

Published Mon, Feb 02 2012 6:25 PM by VSTO & .NET & Excel

Filed under: Tools, .NET & Excel, Excel, XLLs

The Great Microsoft Office Portal

As most of us already know, Microsoft has for the last couple of years built up an enourmus giant knowledge base about Microsoft Office on the internet. As a consequence it has also become more difficult to navigate around and find the wanted information we are looking for. However, today I discovered the Great Portal to Microsoft [...] Read More...

Published Sat, Feb 02 2012 9:46 AM by VSTO & .NET & Excel

Filed under: .NET Books, .NET & Excel, VSTO & Excel, Excel, XLLs, Valentina DB, Valentina Office Server

Office 2010 PIA Redistributable available for download!

I know that some developers have been waiting to get access to Office 2010 PIA Restributable. Although we can create our own IA some developers prefer to use the officially PIA from Microsoft. Today when I checked it up I was pleasant surprise to find out that the PIA package is now available for download. [...] Read More...

Published Thu, Sep 09 2010 12:23 PM by VSTO & .NET & Excel

Filed under: COM Add-ins, .NET & Excel, VSTO & Excel, Excel, XLLs

Creating XLLs with Add-In Express.NET – Part 1

Introduction Recently I had a discussion with a local colleague and friend about using third-party developing tools. He prefers to not use any other tools than Excel and VS.NET. In that way he says he gets 100 % control of the developing process. One of my main targets is to reduce the overall time the [...] Read More...

Published Thu, Jul 07 2010 11:00 AM by VSTO & .NET & Excel