<?xml version="1.0" encoding="UTF-8"?>
<rss xmlns:content="http://purl.org/rss/1.0/modules/content/" xmlns:dc="http://purl.org/dc/elements/1.1/" xmlns:rdf="http://www.w3.org/1999/02/22-rdf-syntax-ns#" xmlns:taxo="http://purl.org/rss/1.0/modules/taxonomy/" version="2.0">
  <channel>
    <title>topic VBScript OpenDoc works inconsistently in QlikView</title>
    <link>https://community.qlik.com/t5/QlikView/VBScript-OpenDoc-works-inconsistently/m-p/554728#M686617</link>
    <description>&lt;HTML&gt;&lt;HEAD&gt;&lt;/HEAD&gt;&lt;BODY&gt;&lt;P&gt;I have a simple VBScript written as follows. This is called from windows command prompt using&lt;BR /&gt; command :&amp;nbsp; cscript -nologo mytest.vbs&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;The mytest.vbs itself is simple as:&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;----- Start of mytest.vbs -------&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;Dim qvwFile, objQV, docObj2&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;WScript.Stdout.Write " Enter QVW File Path: "&lt;/P&gt;&lt;P&gt;qvwFile = Wscript.StdIn.ReadLine&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;Set objQV = CreateObject("QlikTech.QlikView")&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;Wscript.Sleep 2000&lt;/P&gt;&lt;P&gt;Wscript.Echo ("Opening qvwFile: " &amp;amp; Chr(34) &amp;amp; qvwFile &amp;amp; Chr(34))&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;Set docObj2 = objQV.OpenDoc(Chr(34) &amp;amp; qvwFile &amp;amp; Chr(34))&lt;/P&gt;&lt;P&gt;Wscript.Sleep 2000&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;docObj2.Save&lt;/P&gt;&lt;P&gt;docObj2.CloseDoc&lt;/P&gt;&lt;P&gt;objQV.Quit&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;------ End of mytest.vbs --------------&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;When run, gives error "mytest.vbs - Microsoft VBSCript runtime error: Object Required" at the line "docObj2.Save" .&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;If I log off and log back in, it works. I noticed that if for some reason previous run of the script was unfinished or unsuccessful, it leaves something in memory that prohibits next run of this script to run successfully.&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;Anyone else have similar experience? If so, what is cleaner solution?&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;Thanks&lt;/P&gt;&lt;/BODY&gt;&lt;/HTML&gt;</description>
    <pubDate>Thu, 23 Jan 2014 00:17:50 GMT</pubDate>
    <dc:creator />
    <dc:date>2014-01-23T00:17:50Z</dc:date>
    <item>
      <title>VBScript OpenDoc works inconsistently</title>
      <link>https://community.qlik.com/t5/QlikView/VBScript-OpenDoc-works-inconsistently/m-p/554728#M686617</link>
      <description>&lt;HTML&gt;&lt;HEAD&gt;&lt;/HEAD&gt;&lt;BODY&gt;&lt;P&gt;I have a simple VBScript written as follows. This is called from windows command prompt using&lt;BR /&gt; command :&amp;nbsp; cscript -nologo mytest.vbs&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;The mytest.vbs itself is simple as:&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;----- Start of mytest.vbs -------&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;Dim qvwFile, objQV, docObj2&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;WScript.Stdout.Write " Enter QVW File Path: "&lt;/P&gt;&lt;P&gt;qvwFile = Wscript.StdIn.ReadLine&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;Set objQV = CreateObject("QlikTech.QlikView")&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;Wscript.Sleep 2000&lt;/P&gt;&lt;P&gt;Wscript.Echo ("Opening qvwFile: " &amp;amp; Chr(34) &amp;amp; qvwFile &amp;amp; Chr(34))&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;Set docObj2 = objQV.OpenDoc(Chr(34) &amp;amp; qvwFile &amp;amp; Chr(34))&lt;/P&gt;&lt;P&gt;Wscript.Sleep 2000&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;docObj2.Save&lt;/P&gt;&lt;P&gt;docObj2.CloseDoc&lt;/P&gt;&lt;P&gt;objQV.Quit&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;------ End of mytest.vbs --------------&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;When run, gives error "mytest.vbs - Microsoft VBSCript runtime error: Object Required" at the line "docObj2.Save" .&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;If I log off and log back in, it works. I noticed that if for some reason previous run of the script was unfinished or unsuccessful, it leaves something in memory that prohibits next run of this script to run successfully.&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;Anyone else have similar experience? If so, what is cleaner solution?&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;Thanks&lt;/P&gt;&lt;/BODY&gt;&lt;/HTML&gt;</description>
      <pubDate>Thu, 23 Jan 2014 00:17:50 GMT</pubDate>
      <guid>https://community.qlik.com/t5/QlikView/VBScript-OpenDoc-works-inconsistently/m-p/554728#M686617</guid>
      <dc:creator />
      <dc:date>2014-01-23T00:17:50Z</dc:date>
    </item>
  </channel>
</rss>

