Office Developer: Difference between Office Web addin vs COM/VSTO addin

COM or VSTO add-ins are earlier Office integration solutions that run only on Office for Windows. The major difference what you see is that COM addins will be running in the user device or in the Office Client. The new Office Add-ins don’t involve code that runs on the user’s device or in the Office…


Outlook 2016 – When you try to create a macro in Outlook receive error messages "Unexpected error, quitting" and "Out of memory"

One of my customer reported that he installed Office 2016 on a PC and tried creating a macro in Outlook then he received error messages "Unexpected error, quitting", followed by "Out of memory". We tried opening the Outlook VBA Editor, unfortunately it doesn’t open either. Alternately we checked and made sure that they don’t see…


New name for Apps for Office and SharePoint? Office and SharePoint Add-ins

As you aware that you can use Office and SharePoint Add-ins to extend Office applications with content directly from the web or to extend SharePoint websites. But do you know the “new name” for “apps for Office and SharePoint”? Yes, the platform name will be changed from "apps for Office and SharePoint" to "Office and…


Office Developer : Outlook & VBA Programming # 2

In addition to previous article, I would suggest you to have a look at the related articles for reference/samples etc: Microsoft Office Outlook 2003 Inside Out 101 VBA samples for Office 2010 VBA for Office developers Office 2003 Editions: Outlook VBA Language Reference Automating Outlook from a Visual Basic Application Automating Outlook from Other Office…


Office Developer : Outlook & VBA Programming # 1

By using Visual Basic for Applications (VBA), a simple but powerful programming language that you can use to extend Office 2010 applications with new capabilities and automate repeated tasks. I remember VBA is used for a long time in Microsoft Office based applications. I thought to combine the list the related articles that are pretty…

1

Outlook Object Model: How to include usemap attribute programmatically?

In this post, I will show you how to make use of usemap attribute of img HTML element in HTML emails programmatically. For this, I used Outlook 2010 VBA & Outlook Object Model. You can design the application with C# or VB.Net with Outlook Object Model library as per your wish. We will do this…


Microsoft Excel 2010 Developer Challenge – Soccer Edition

There is just over a month to the kickoff of the 2010 World Cup in South Africa and under a month to the launch of Microsoft Office 2010-  coincidence? += + Cool apps that surprise and delight users—built by developers like you—are a big part of the Microsoft Excel 2010 vision.     If you’re into developing…

1

Where i can find the Macros & Visual Basic Editor in new Microsoft Outlook 2010?

Couple of Outlook 2010 beta users reported that they can’t find the old VBA (Visual Basic for Applications) and Visual Basic Editor in new Outlook 2010? Whether the feature is removed? With respect to my last blog post, VBA is available with Outlook 2010. Let me explain in-detail. We know about how Outlook 2010 applications…

8

Development : Is Visual Basic 6.0 Runtime still supported?

We get many request/references regarding support of Visual Basic 6.0 runtime support for various Microsoft Operating systems including MS Windows 7. There is a wonderful article regarding this MSDN article titled “Support Statement for Visual Basic 6.0 on Windows Vista, Windows”. It states that the “…Visual Basic team is committed to “It Just Works” compatibility…

2

Playing with Journal Items & Outlook Object Model # 3

Reading Journal attachments using Outlook Object Model: This time, i tried to read all the email and their attachments using Outlook Object Model. I used the following code snippet to do this. ‘Code Snippet : How to retrieve Outlook attachments using Visual Basic for Application (VBA) Dim omailitem As Outlook.JournalItem Dim myJournal As Outlook.Items Dim…

2

Playing with Journal Items & Outlook Object Model # 2

After created couple of journal items in my test lab, i thought this time i want to play around with the Journal items. Also i want to try the following programmatically: 1) iterate all the available journal items 2) Restrict the values with a (if the Lastmodificationtime > ‘23/9/2009’) specific time frame For this i…


Playing with Journal Items & Outlook Object Model # 1

I want to share my research (that i tried to play around with Journal items) with respect to Outlook Object Model API to you. How to create the new Journal Item programmatically using Outlook Object Model? Now, we can try how we can create a new Journal Item.Code snippet: Creating a new Journal Item with…


Interesting blog post : Office 2010 & VBA – Why VBA Still makes sense?

I found this interesting blog post from John Durant with respect to VBA. Why VBA Still Makes Sense Not infrequently I am asked, “So, should I use VBA? Is it going to be around in Office 2010? Is it supported? Should I migrate away from VBA now? Can I count on this technology?” (Here I…


Outlook Object Model : Creating Outlook Categories programmatically and assign colors, shortcut keys to that

In this blogpost, we will try to create the Outlook Categories programmatically using Outlook Object Model API. Also we will assign the relevant colors and shortcuts to that. Whenever we try with Outlook Object Model, it’s relatively simple. ‘[Code snippet to create Categories] Private Sub CreateCategory()   Dim objNameSpace As NameSpace Dim objCategory As Category…

1

Outlook Object Model : Creating simple tasks programmatically using OOM & VBA?

In this post, we will create the simple Outlook tasks programmatically using Outlook Object Model API & VBA. We do this by using the code snippet: ‘[Code Snippet for creating Simple Tasks using Outlook Object Model API & VBA]   Private Sub CreateTasks() ‘Declare the Task item Dim objTask As TaskItem   ‘ Create Outlook…

3