Just came across a promising add-in for Excel.
Its called Vizubi Excel and is part of a larger Development / Data platform
You can use it to load data from QVD’s ( Qlikview data [blob] files )
The beauty is the Add-In for Excel is free … but only available in a 32 bit version
So no I need to set-up a 32 bit installation and go back in time to test this…
Does anybody have any experience with Vizubi please let me know…
If one has installed a 64 bit Windows OS and he tries to use the 32 bit Qlikview 9 application
He can encounter the following error message:
SQL Error:[Microsoft][ODBC Driver Manager] The specified DSN contains an architecture mismatch between the Driver and Application
This means you can’t use the 64 bit driver with the 32 bit application.
One should run odbcad32.exe from the SysWOW64 system folder and create an ODBC (32 bit) link.
This ODBC link can have the same name as a 64 bit one and can only be accessed / edited / viewed via this executable.
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.