Kunal-Chowdhury.com - Microsoft Technology Blog for developers and consumers: Office
Showing posts with label Office. Show all posts
Showing posts with label Office. Show all posts

Restore corrupted PST files using Stellar Phoenix Outlook PST Repair

Due to improper closing of Outlook data files, this happens many times when the mails in the 'Inbox' folder are inaccessible. Therefore you would not be able to read and reply important mails. Also, the default Outlook PST Repair Tool is unable to fix that issue! Now what to do?

 

Most people will panic in such a situation, but the ideal deal is to move forward and install the Phoenix Outlook PST Repair Tool from Stellar.



Here's how to retrieve Process details of Excel, PowerPoint app instance

If you are using COM objects like Microsoft Excel or Microsoft PowerPoint, you may sometime notice that the COM instances are not releasing from the process list; even though you called Close(), Quit() on the application instance.

 

In case you faced the same issue, this post will guide you to find the Process ID (from the HWND) of that particular instance to take further action to release it.


Solution for NPOI only supports BIFF8 format exception

In last few articles we have discussed about NPOI libraries for .NET. There could be some cases, while reading Excel files, you may get an exception with 'The supplied spreadsheet seems to be Excel 5.0/7.0 (BIFF5) format. POI only supports BIFF8 format' as message.

 

In this quick tip, we are going to discuss about this issue, the way to handle it and the way to read the same Excel workbook content.


Here's how to read Excel 95 or older document (XLS) using NPOI libraries

In the last two articles, we have learned how to use the NPOI library to read Excel 2007 (.xlsx) and Excel 97-2003 (.xls) file format. We have also discussed more about the APIs and shared the code snippet for you to understand it easily.

 

In this article, we will learn how to read Excel 95 and older workbooks easily using the free Apache NPOI libraries in your C#/.NET applications.


Here's how to read Excel 97-2003 document (XLS) using NPOI libraries

In the last article, we have discussed about the NPOI library and then learned how to read Excel 2007 file formats using the free, open sourced NPOI library. I hope, the code snippet was clear and easy to understand.

 

In this article, we will learn how to read Excel 97-2003 workbooks easily using the free Apache NPOI libraries in your C#/.NET applications.


Here's how to read Excel 2007 document (XLSX) using NPOI libraries

Recently, we have learned how to read Excel workbooks using the Microsoft Office COM APIs. As you may already know that the COM APIs are slow while performing operation, we will see another way to read the content which is faster.

 

In this article, we will learn how to read Excel 2007 workbooks using the Apache NPOI libraries which is available freely to use in your application.



Microsoft Word returns Error 800A175D - Could Not Open Macro Storage

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.


Email got stuck in Outbox folder? Check out this solution

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.


How to repair Microsoft Outlook data files using scanpst tool?

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.


ERROR: Attempting to open a Office file type that is blocked

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.


Here's how to read emails from Outlook using C#

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.



COM Exception from HRESULT: 0x80080005

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.


How to read Microsoft PowerPoint document contents using C#/.NET?

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.


How to read Microsoft Excel document contents using C#/.NET?

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.


How to read Microsoft Word document contents using C#/.NET?

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.


How to convert an Excel column into a comma separated list?

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.



Outlook 2016 features mentions inside mail body

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.


How to retrieve the correct Microsoft Office product version?

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.


Office 365 June Update - New build version 16.0.6965.2058 available

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.


A collection of Keyboard shortcuts for Microsoft #Outlook

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.

 
© 2008-2017 Kunal-Chowdhury.com - Microsoft Technology Blog for developers and consumers | Designed by Kunal Chowdhury
Back to top