Office

Showing posts with label Office. Show all posts

If you are using Microsoft Word Automation or COM Components to read a MS Word document, you may notice the following error message for few word documents "Error 800A175D - Could Not Open Macro Storage".

 

This is caused by the user account, whose "user hive" is not loaded when Microsoft Word started. Continue reading to know more about the issue and solution.

Published by on under Microsoft Word | Office

This happens many time when the mail, that you are going to send, gets stuck in the Outbox folder of your favorite email client and provides you 'No Luck' to open/delete that email as it already started transmitting to the other side.

 

If you are one of such victim, here's a quick tip for you to easily stop transferring that mail, so that, you can open or delete it.

Published by on under Office | Outlook

SCANPST.EXE is a Inbox Repair Tool for Microsoft Outlook to diagnose and repair errors in Outlook data file. If your Microsoft Outlook Data File (.pst and .ost) won’t open or if you suspect the file has been corrupted, use this tool to repair the file.

 

In this blog post, we will discuss how to repair the data files associated in your Microsoft Outlook client. Continue reading to learn about it.

Published by on under Office | Office 2013

When you try to open any office file documents created with an earlier version of Office applications like Word 95, Word 6.0 or Word 2, the file will open in 'Protected View' by default and the editing functions will be disabled.

 

Though it is not recommended, but if you face such issue and still want to open the document for editing, you can follow the steps mentioned here.

Published by on under Office | Office 2013

You would like to build an application/addin that reads outlook mail and notify the user or would like to do some other operations based on your business need. For this, you will need to use the Microsoft Outlook APIs.

 

Today we are going to see, how this can be done using the Microsoft.Office.Interop.Outlook.dll to read the email from Outlook context and extract the data.

Published by on under .Net | C#

While working with Microsoft Office Interoperability, you may face the following exception that states: "COMException (0x80080005): Retrieving the COM class factory for component with CLSID failed due to the following error: 80080005".

 

This issue happens when Outlook is already running and you are trying to access it's mailbox from Visual Studio environment. Let's discuss more about the issue.

Published by on under Office | Outlook

Recently we learnt how to read Microsoft Word and Microsoft Excel document contents (text only) using the interop APIs exposed by Microsoft. Now, what about reading the text content from PowerPoint slides? This can be achievable using another interop assembly file.

 

Today we will discuss how to extract the texts available in PPT files using 'Microsoft.Office.Interop.PowerPoint.dll'. Code has been shared for your easy reference.

Published by on under .Net | C#

Recently, we learned how to read text contents of Microsoft Word document from a .NET application using the APIs exposed in 'Microsoft.Office.Interop.Word.dll'. There may be a business requirement to read contents of Excel sheets too.

 

Today we are going to learn how to read Microsoft Excel documents. The complete source code has been shared for your easy reference.

Published by on under .Net | C#

There could be some possible business needs for your .NET application to read the text contents from a Microsoft Word document. This can be simply done using the APIs exposed in the dll named 'Microsoft.Office.Interop.Word.dll'.

 

Let's have a quick look on how to do it using C#/.NET. Also find the complete source code shared here for your easy reference.

Published by on under .Net | CSharp

There are several instances when we need to make a comma separated text values from an excel column. There are different but pretty lengthy process that you can find, which will eat a no. of your valuable time to process the same.

 

So, what to do? Today we are going to learn a quick and easiest way to copy a column of data to a comma separated list. Continue reading to know more.

Published by on under Excel | Microsoft 365

Outlook 2016 brings a new set of features with the July update by which you can get someone's attention in the body of the email message or a meeting invite very easily. It will not only include their name highlighted in the body, but also add them to the “To” field.

 

This feature is currently available to Office Insiders and going to roll out soon. Let’s see brief about this new feature before it comes to public release.

Published by on under Office | Office 2016

If you are addin developer for any Microsoft product, you might have in need to find out the exact version no. of the office product. You can get it from the app version from the interop libraries, but that doesn't return the correct one to you.

 

So, how to retrieve it? Today in this small post, we will find out the way to get the correct version no. If you know any alternate way, will highly appreciate if you do share it with us.

Published by on under .Net | Office

Microsoft released a new update (Build 16.0.6965.2058) for Office 365 client aka. Office 2016 (Version 1605) on 14th June 2016. This includes one security fix and seven non-security related fixes. If you are using Office 2016, check for updates.

 

This post will cover the list of fixes part of this Microsoft Tuesday patch. Continue reading to further know about the changes.

Published by on under News | Office

When you are more used to with some application software and if you use it daily on a high volume, it's sometime good to learn the keyboard shortcuts of the features that you perform regularly. Outlook exposes a lot of such shortcut keys for you to perform better.

 

It's not always possible to learn all of them, but good to have the list to learn/view time to time. Here I am listing all the shortcuts of Outlook 2010 - 2016, for your reference.

Published by on under Office | Office 2013

Microsoft released a new update (version: 16.0.6965.2053) for Office 365 client applications. This includes some new features with some non-security fixes. If you are using Office 365 client or Office 2016, check for office updates.

 

This post will cover the new changes and the list of fixes bundled with this build. Continue reading to know about it further.

Published by on under News | Office

Microsoft released a new update on 23rd May for it’s entire set of Office 365 client applications, incrementing the version to 16.0.6868.2067. It’s the third update that they pushed in this month (May 2016) and contains all non-security updates.

 

Checkout this post to know about all the fixes they pushed in this build, though the folder pane visibility issue is still untouched.

Published by on under News | Office

If you are using Outlook 2016 or any prior version of it and facing issue related to the first pane/left pane/folder pane/navigation panel/navpane, which is frequently disappearing after outlook restart, this post will help you to resolve it.

 

Just follow the simple steps mentioned here in this post and let us know, if this solves the problem that you are looking for.

Published by on under Office | Office 2016

You might have already hear about Clippy. Yea, that’s the Office Assistant that we had in those days. In earlier office versions it helped us with many quick tips to complete the job easily, having some nice animations. If you are fond of it and want to use it in your development environment, there is a cool ReSharper extension for Visual Studio.

 

Recently I came across it and thought to share with you more details about the extension as well as some snaps and the process to install it. The extension is also available as opensource project on GitHub. Continue reading to know more.

Published by on under JetBrains | Office

If you are running Microsoft Office 2010 and a regular user to it’s Outlook product, you might have recently observed that, many buttons, menus changed their state to disabled mode. If you are using any add-ins, those became disabled. This is because your Outlook switched into Safe Mode.

 

This is quite obvious and actual reason behind this is a little bit different. In this post, we will discuss more about the issue and a quick fix to resolve it. Continue reading.

Published by on under Office | Outlook

If you are building add-ins for Microsoft Word, at the time of add-in installation you might want to check whether user has installed MS Word on his system or not. Based on that, you might want to show a message to the user or take proper action as per your business need.

 

In this small blog post, we will learn what needs to be done using C# to find out whether the said Microsoft Office product is installed or not. Continue reading to know about this coding tricks.

Published by on under CSharp | DZone