After installing Office 2016 Version 1609 Office files containing VBA Form may hang the Office application [Update: Fixed in Office 2016, 1610 build]

Issue If an Office file has a UserForm which has Cycle Property set to “2 – fmCycleCurrentForm” (or any other control which has this property set) then the Office application may hang while trying to show this UserForm in Office 2016 Version 1609. Cause This is a bug which is being worked by Product group….


VSTO Add-in may fail to load if signed by some SHA256 certificates

Symptom VSTO add-in may fail to load if all of the following conditions are true:- The SHA256 certificate used to sign the add-in is based on SHA256 algorithm (http://www.w3.org/2000/09/xmldsig#rsa-sha256) “Require Add-ins to be signed by Trusted publisher” setting is checked in Office Trust Center. The deployment manifest is not accessible (For e.g. you installed the VSTO…


Considerations for common performance issues with Office Add-ins and Macros in Office 2013

The intent of this blog post is to address frequent questions that we see comparing performance difference between Office 2010 and 2013, especially by developers who use Office as a development platform via macros using VBA, add-ins, COM add-ins and interop using C++ / a .Net languages such as C#, VB.Net. Before we compare the performance…


After installing MS15-022 update you may not be able to run HTML script under Office context

Symptom After installing MS15-022 update you may not be able to run HTML script under Office context Cause This security update opts Microsoft Word, Excel, or PowerPoint into local computer lockdown, a feature control for Internet Explorer, to prevent scripts in Office documents from running with elevated user rights. Here are documentations which explains this…


Using MSBUILD through command line or from TFS Server to compile VSTO projects may fail with error ‘The "SignFile" task could not be initialized with its input parameters’

Symptom You may get the following errors if you try to compile VSTO Projects through MSBUILD through command line or from TFS Server Post Visual Studio Update 3 C:\Program Files(x86)\MSBuild\Microsoft\VisualStudio\v12.0\OfficeTools\Microsoft.VisualStudio.Tools.Office.targets (268): The “TargetFrameworkVersion” parameter is not supported by the “SignFile” task. Verify the parameter exists on the task, and it is a settable public instance…

2

ActiveProject.CustomDocumentProperties may return ‘null’ for Applications Compiled using Visual Studio 2010 C# express edition

Few days back I worked on an issue where an application compiled using Visual Studio 2010 C# Express edition was getting ‘null’ at “Application.ActiveProject.CustomDocumentProperties” when trying to follow below article : How to Use Automation to Get and to Set Office Document Properties with Visual C# .NEThttp://support.microsoft.com/kb/303296/en-us Cause The issue was found to be due…


Office automation through VC++ using MFC Class from TypeLib results into large number of compilation errors

When trying to Automate Excel, Word, etc using VC++ (MFC based application) in Visual Studio 2010 we generally perform the following steps –   1-Go to Visual Studio 2-Click New Project 3-Expand Visual C++ tree node 4-Choose MFC 5-Select MFC Application 6-Enter project name, click OK 7-Choose a dialog based project 8-Click Finish 9-The bare bone…

0

Customizing Office 2013 backstage

Office 2013 introduced many changes to the backstage. In this blog post we will see how Office 2013 backstage can be customized using the backstage XML. The list of idMso’s for Office 2013 can be downloaded from: http://www.microsoft.com/en-us/download/details.aspx?id=36798. We’ll modify the blog post based on your feedbacks. Let’s get started with the idMso(s) of the…

2

VB6 based add-ins may fail to work in Office 2013

VB6 based add-ins have a dependency on the Add-In Designer Object Library (msaddndr.dll), which is no longer shipped with Office 2013 (http://technet.microsoft.com/en-us/library/cc178954.aspx see under OSF section). If the add-in setup project did not include this DLL, then the Add-in registration would fail. To resolve this issue :- 1. The add-in developer can include the msaddndr.dll file…

5

Considerations for using Dsofile on 64 bit OS

This post is by Yeshwanth Channaraj. There is a well-documented sample program, DSOFile, that enables reading and writing Office document properties (both old format files like *.xls, *.doc and *.ppt, as well as the new open xml formats like *.xlsx, *.docx and *.pptx). The DSOFile sample is compiled as 32 bit. If you are using…

0