Microsoft Office Excel ActiveX Fix

 

As planned, Microsoft released a security patch for an Office ActiveX vulnerability on 12/9/2015. Any dated (and I mean code as old as 10-years) Excel VBA macros with ActiveX controls no longer work post-patching. Here are some links if you need to understand more:

Official Microsoft Excel Blog

Frankly, the ideal way to repair this issue is to replace the underlying vulnerable ActiveX VBA code.

Where that isn’t practical, the following fix works for Excel 2007 and Excel 2010, but you need a working unpatched machine to start.

Working directory – C:\Users\%Username%\AppData\Local\Temp

Folder and files to copy –

C:\Users\%Username%\AppData\Local\Temp\Excel8.0

C:\Users\%Username%\AppData\Local\Temp\VBE

Copy and replace the working folders to the broken machine and the macros should start working again.

Each of the directories above contain uncorrupted *.exd files. The issue is resolved when you replace the corrupted files on the broken PC.

Email me if you need a working copy of the files.

Still digging into Excel 2013…

 

DS

Advertisements

About Doug Sigmon

IT Helpdesk manager in southern California. Love technology, gadgets, and golf.
This entry was posted in Uncategorized. Bookmark the permalink.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s