topic Re: Automation from VBA problem in QlikView https://community.qlik.com/t5/QlikView/Automation-from-VBA-problem/m-p/803942#M283833 <HTML><HEAD></HEAD><BODY><P>I found the V11.2 automation reference and section 4.3 "Untyped VB with Qlikview Automation".</P><P></P><P>I re-wrote that part of the app to use Untyped VB and the problem appears to have gone away.</P><P></P><P>Bob</P></BODY></HTML> Sun, 15 Mar 2015 13:01:04 GMT 2015-03-15T13:01:04Z Automation from VBA problem https://community.qlik.com/t5/QlikView/Automation-from-VBA-problem/m-p/803941#M283832 <HTML><HEAD></HEAD><BODY><P>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. </P><P></P><P>One of my users (and only one!!!) running Windows 7 is having a problem. </P><P></P><P>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.</P><P>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.</P><P>2. I have checked all the settings for the Qlikview client and they seem the same.</P><P></P><P>Any ideas?</P></BODY></HTML> Sun, 15 Mar 2015 11:59:42 GMT https://community.qlik.com/t5/QlikView/Automation-from-VBA-problem/m-p/803941#M283832 2015-03-15T11:59:42Z Re: Automation from VBA problem https://community.qlik.com/t5/QlikView/Automation-from-VBA-problem/m-p/803942#M283833 <HTML><HEAD></HEAD><BODY><P>I found the V11.2 automation reference and section 4.3 "Untyped VB with Qlikview Automation".</P><P></P><P>I re-wrote that part of the app to use Untyped VB and the problem appears to have gone away.</P><P></P><P>Bob</P></BODY></HTML> Sun, 15 Mar 2015 13:01:04 GMT https://community.qlik.com/t5/QlikView/Automation-from-VBA-problem/m-p/803942#M283833 2015-03-15T13:01:04Z