topic AW:VBS Error the 2nd time reload script runs in QlikView

VBS Error the 2nd time reload script runs

Tue, 18 Aug 2009 16:24:14 GMT

Hi,

I have a VBS script to open a qlikview document, reload it (which then runs a macro on post reload to print RP01 to PDF) then close the document.

The first time i ran the script it ran ok, however now when i run it I get a windows scripting error.

I've attached my code and the error - can anyone help?!

Thanks

Helen

AW:VBS Error the 2nd time reload script runs

biester — Wed, 19 Aug 2009 13:27:39 GMT

Hi Helen,

is everything OK now with the QVW now? To me it seems that the first run of the script has corrupted the file (probably by the reload - I have no idea how, but it seems so; perhaps it might also be a lock) and the second run only found a corrupt QVW which cannot be opened anymore - so the OpenDoc command did not result in a valid object which is of course necessary for the ReloadEx method.
I can provoke this when I corrupt a qvw on purpose and then run the script on this file.

Rgds,
Joachim

AW:VBS Error the 2nd time reload script runs

Wed, 19 Aug 2009 15:29:17 GMT

Hi Joachin,

Thanks for the response. I didn't manage to get it working with the VBS - your answer makes sense as i did have problems with the file. I've got it working with .bat files now.

Thanks

Helen