MSI – Generate SHA2 certificate with OpenSSL and sign a MSI installer project, use ‘Application Control Policies’-‘AppLocker’ to block unsigned code

Some time ago I had to troubleshoot an issue with signed native C++ XLL add-ins for Excel, which didn’t get loaded with certain combinations of Excel and Windows. Symptom – A client has developed an unmanaged XLL add-in for Excel, which has been signed with a code signing certificate that uses SHA2 as hashing algorithm.- Everything…

3

VSTO – .Net code throws ‘System.AccessViolationException’ error when automating the ‘Find’ object in Word (KB 292744 BUG: Automation client receives an error message or crashes when the client calls the Find object in Word)

Sometimes users are running versions of Office which are not fully up-to-date. This might be due to the fact that their local IT department has not tested the new patches and did not approve their company wide distribution, or because the machine is not connected tothe Internet and needs to be manually updated .. or some other reason. At the same…

1

OpenXML & VSTO & VBA – Finding a reliable mechanism for reading the correct value of CharactersWithSpaces ‘extended-properties’ in Word documents [part 2/2].

  This article is split across two blog posts and this is part #2 .. use this link to go to part #1. In part #1 of this article, I demonstrated how words are counted using OpenXML and I warned about the dangers of not getting it done correctly. Here is a short summary of the alternatives we have:    Can we obtain 100% reliable statistics? Method #1:       When Word…

0

OpenXML & VSTO & VBA – Finding a reliable mechanism for reading the correct value of CharactersWithSpaces ‘extended-properties’ in Word documents [part 1/2].

  This article is split across two blog posts and this is part #1 .. use this link to go to part #2. There are many scenarios when we have to know exactly how many words, pages, paragraphs or characters are found in a certain document:    > we might be developing a tool which searches through files; If we want to add OpenXML files to       its list of…

0

VSTO & VBA – Improving Excel’s performance when writing data into Sheets by using memory arrays instead of inefficient code loops

In my previous article (VSTO & VBA – How to troubleshoot Excel memory and performance problems caused by inefficient code loops) I wrote about a few common issues which may be encountered when trying to read data from an Excel workbook using COM automation. But after you finished reading it, maybe you asked yourself: What…

0