Archive for June 27th, 2011

Using a computer with multiple versions of office installed in combination with Qlikview.

June 27th, 2011 admin No comments

We were experiencing problems with a qlikview report containing a script which mailed parts of a certain tab as embeded pictures.

The line of code qlikview errored on was: Set OutApp = CreateObject(“Outlook.Application”)

The error was: ActiveX component can’t create object: ‘Outlook.Application’

The user with this problem also had problems with sending a excel workbook as an attachment from excel and got the error message:

This led me to believe that the additional installation of some Microsoft Office 2003 products were the reason for this strange behavior. In Qlikview you don’t reference a version of the ActiveX component like in vba so I assume the latest installation is leading.

To prevent these kinds of errors one should do a repair of the office installation considered to be leading.

Categories: Excel, Qlikview Tags: ,