Skip to main content
Announcements
See what Drew Clarke has to say about the Qlik Talend Cloud launch! READ THE BLOG
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Error connecting to QV Server through Excel VBA (using ActiveX)

Hi All,

This is a slightly different issue from what has been asked previously many times by many of the users.

Context:

QV Client type:  Internet Explorer Plugin (using the ActiveX object)

QV Server Version: 11.20.13405.0

QV Dashboard location:  Dashboard lies in a remote QV Server

I have an Excel workbook with macros in it which connects to the remote QlikView server and pulls the required data for some of our internal reporting.

Macro basically uses  the C:\Program Files (x86)\QlikView\QvPlugin\QlikOcx.ocx  Active X file to connect to the QV server and extract data underlying a particular Object ID.

Issue:

One of the users when trying to run the macros gets the error "Failed to open document. You don't have access to this document."

A few quick notes:

  1.   Two other users are able to run the excel macro  and extract the required data from the remote QV server successfully

  2.   User getting the error message has the following:
    • user has the C:\Program Files (x86)\QlikView\QvPlugin\QlikOcx.ocx  installed
    • user has access to the dashboard
    • user is also able to view the dashboard through Internet Explorer with out any issues
    • QV server mgmt team confirmed that the user has the same access levels as the other 2 users.
    • But when this particular user is trying to run the macros, the error "Failed to open document. You don't have access to this document." pops up.

Any help/suggestions on this please ?

Thanks so much for all your time n help in advance…

Prashant_CV

0 Replies