Skip to main content
InSource KnowledgeCenter

043827 - The Workbook has lost its VBA Project, ActiveX controls and any other programmability

Problem

Gets the following error when starting HistClient Workbook HistClient.xla 'The Workbook has lost its VBA Project, ActiveX controls and any other programmability' Just installed a fresh copy of Historian Client and Office 2007.

Product Version: 10.1

Solution

Turns out that he has to install Visual Basic for Applications in Microsoft Office. He needed to go to Add/Remove Programs, Microsoft Office (Select CHANGE), and then go to Shared Office Applications, then select to install Visual Basic for Applications. This resolved the issue! Ok to close

Close Date: 2012-04-30 16:20:37