Posts Tagged ‘VB.NET’
New version of Add-in Express sample COM add-in projects
Andrei Smolin | July 1st, 2020
Quick news: we've developed a new version of sample COM add-in projects that we provide in the downloadable archive on the Add-in Express .NET Downloads page... Read the rest of this entry →
Support for Office 2019 is added to Add-in Express for Office and .net
Dmitry Kostochko | November 23rd, 2018
Version 9.2 of Add-in Express for Office and .net is published, and we now announce full support for all versions of Office 2000 through 2019 32-bit and 64-bit... Read the rest of this entry →
Localization of Office add-ins using forms-based resources
Dmitry Kostochko | December 20th, 2016
The article describes how to create a localized version of an Office add-in by using regular forms-based resources without having to apply them manually to each component, form or control... Read the rest of this entry →
Using Outlook Recipient and Recipients collection – guide for developers
Ty Anderson | September 18th, 2014
Writing email can get you in a lot of trouble if you are not paying attention. I can tell you about some seriously funny (on retrospect) situations caused when I inadvertently added a recipient that I did not intend to add. I can tell you but I won't (unless we meet in person and you buy me a beer). Let's just say that Outlook's autofill feature is not your friend and is not to be trusted... Read the rest of this entry →
Outlook Address Book – complete guide for developers
Ty Anderson | August 1st, 2014
Out-of-the-box, Outlook'is address book is the default contacts folder that resides in a user's Outlook folder structure. In a typical Outlook installation, there is a single contacts folder and feeds the TO, CC, BCC fields in the Outlook email form. In any form that supports assigning a contact to it, the default address book feeds it as well... Read the rest of this entry →
Exception from HRESULT 0x800A01A8 in PowerPoint solutions
Andrei Smolin | June 24th, 2014
On an example of a simple scenario, this article demonstrates what causes 0x800A01A8 and how to avoid it in C#, VB.NET, VBA, Delphi. Exception from HRESULT: 0x800A01A8 is also known as OLE error 800A01A8 and also known as Object Required.... Read the rest of this entry →
PowerPoint 2013 add-in development in Visual Studio: Application and base objects
Ty Anderson | February 12th, 2014
Like all Office apps, the main object in the PowerPoint object model is the Application object. Underneath it we have a few key objects that will allow us to achieve most of our development goals. Here is summary of PowerPoint's base objects... Read the rest of this entry →
Creating a custom Send button in Outlook
Ty Anderson | January 30th, 2014
Microsoft does not provide us with a way to customize the Send button using the Outlook object model. We can't change its caption, size, colors, etc. This is just how it is. Microsoft is happy with the Send button as-is and doesn't want us messing with it... Read the rest of this entry →
How to find the last used cell (row or column) in Excel
Ty Anderson | December 6th, 2013
VB.NET code samples explain some reliable methods for finding the last used cell in an Excel worksheet or a range.... Read the rest of this entry →
Convert an Excel column number to a column name or letter: C# and VB.NET examples
Pieter van der Westhuizen | November 13th, 2013
There are a lot of examples floating around on the internet on how to convert Excel column numbers to alphabetical characters. There are a few ways to get the column letter, using either vanilla C# or VB.NET, Excel formulas or the Excel object model. Let's take a look at some of the solutions... Read the rest of this entry →
Working with Excel tables & ranges: VB.NET code samples
Ty Anderson | October 24th, 2013
Microsoft Excel, being a spreadsheet application, automatically brings structure to your thinking. You can build models to help you think through just about anything. You can organize your data and create lists of any imaginable type. In fact, most apps in the mobile app stores these days can easily be replaced by Excel files. Even games... Read the rest of this entry →
Customizing Excel main menu, context menus, and Backstage view
Ty Anderson | October 2nd, 2013
Today we will tackle the issue of customizing Excel menus and back stage view. As you know, there are multiple versions of Excel "in-play" and it is wise to architect your solutions to work seamlessly with them. Add-in Express provides the tools, but it helps to know how to use them... Read the rest of this entry →
Excel add-in development in Visual Studio: Application and base objects
Ty Anderson | September 23rd, 2013
Today we start a new series to explain the basics (and more) of Excel add-in development. This is going to be serious fun because Excel rocks. Next to Outlook it might be the most popular target of Office add-ins... Read the rest of this entry →
Using custom XML parts in Word add-ins
Ty Anderson | August 23rd, 2013
Custom XML parts are chunks of XML that reside within a Word document. They are not part of the document, per se, because they are not visible to the user. Starting with Office 2007, the Office file formats are XML-based and are comprised of XML parts... Read the rest of this entry →
Working with Word document designs, styles and printing
Ty Anderson | August 15th, 2013
Designing Microsoft Word documents is not all that different from designing a web page; you want to keep the content and the design separate. In Word, you keep them separate by utilizing styles. Styles include a plethora of design elements (e.g. font, borders, paragraph format, etc). Let's have some fun with them via code... Read the rest of this entry →
Working with Word document content objects
Ty Anderson | August 7th, 2013
Microsoft Word is about the authoring of documents. Documents contain pages, paragraphs, sentences and more. Today, I want to wade into the waters of manipulating Word document content. The plan is to get your feet wet by providing an overview of the key objects along with code samples... Read the rest of this entry →