Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Highlighted
Not applicable

Automation from VBA problem

I have an app that we developed in house that automates the creation of charts and pastes them into PPT. It runs from VBA in XL 2007.

One of my users (and only one!!!) running Windows 7 is having a problem.

At the line Set qvDoc = GetObject(thisQVDoc), an instance of Qlikview loads, but it doesn't load the document referenced in the thisQVDoc variable. I get a time out error.

1. If I copy the value from the thisQVDoc value to the "file open" dialogue, then the document opens OK, so it's not a problem that the path is not accessible from that machine.

2. I have checked all the settings for the Qlikview client and they seem the same.

Any ideas?

Tags (2)
1 Solution

Accepted Solutions
Not applicable

Re: Automation from VBA problem

I found the V11.2 automation reference and section 4.3 "Untyped VB with Qlikview Automation".

I re-wrote that part of the app to use Untyped VB and the problem appears to have gone away.

Bob

View solution in original post

1 Reply
Not applicable

Re: Automation from VBA problem

I found the V11.2 automation reference and section 4.3 "Untyped VB with Qlikview Automation".

I re-wrote that part of the app to use Untyped VB and the problem appears to have gone away.

Bob

View solution in original post