Category Archives: Office

Using PowerShell + Word Interop to Extract Tables from PDFs

I needed to extract some tables from PDFs. If you’ve ever done this before you realise PDF format doesn’t really contain table information, it just contains lines and positions of text. Testing out Tabula http://tabula.technology/ which worked reasonably well, but … Continue reading

Posted in Office, PowerShell | Tagged | Leave a comment

Case of the Skype for Business 2015 “Operating System is not presently configured to run this application”

On Windows 10 build 10162 after installing Office 2016 Skype for Business started throwing the error: The operating system is not presently configured to run this application. Using Task Manager I right clicked lync.exe and created a dump file. Opening … Continue reading

Posted in Click2Run, Office, WinDbg, Windows 10 | Tagged | 2 Comments

Case of the Visual Basic Environment Could Not Be Initialized

Launching Word we got the following error: Clicking Show Help we get some explanations of potential causes: This error is usually caused by insufficient memory or low disk space. It also occurs when the default Word template (normal.dotm) is corrupt, … Continue reading

Posted in API Monitor, Office | Tagged | 5 Comments

Case of the Word Scroll Hangs in Citrix

A simple one page document was causing Word to freeze on opening, and if it ever did open, attempting to use scroll bar caused some parts of a background image to appear intermittently. 3 dump files were collected using Task … Continue reading

Posted in Citrix, Office, WinDbg | Tagged | Leave a comment

Case of Excel Conditional Formatting Hang

Previously we saw network traffic causing a hang https://chentiangemalc.wordpress.com/2014/08/21/case-of-the-excel-hang-on-worksheet-open/ This time no network traffic was occurring when launching a customer’s payroll Excel Application (XLS file). The application hang occurred in Excel 2010 and 2013, but not in Excel 2003. As … Continue reading

Posted in API Monitor, Debugging, Office | Tagged | Leave a comment

Case of the Excel Hang on Worksheet Open

Excel was hanging for a long time on a very simple spreadsheet, with no macros, no Office File Validation, and no crazy add-ons, whenever the “Header” worksheet was first activated.   Launching excel with ProcDump http://live.sysinternals.com/ProcDumpe.exe in hang mode, we … Continue reading

Posted in Excel, Office, WinDbg | Tagged | Leave a comment

App-V Visio and Thick Excel Collide

A 3rd party Excel add-in had stopped working for a group of users, and they all received an error message on launching Excel: Microsoft Visual Basic for ApplicationsSystem Error &H8007007E (-2147024770) Unfortunately the VBA code in question was from the … Continue reading

Posted in App-V, Office, ProcMon, SysInternals | Leave a comment