Automation from VBA problem

[#1]

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?

[#2 · Accepted solution]

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