Problem with command line and macro to mail reports in Windows Tasks

agrisyst — Wed, 10 Nov 2010 15:08:32 GMT

Hello all,

My problem is the following.

Updated to QV9 SR6 and now some of my windows task do not work anymore.

Intention: I have a QV application which start, and reloads in Windwos Tasks (once a week). Works well

qv.exe /r 'filename'

Now I have added a macro whichs runs on reload (the macro, prints report to PDF and mails to several people). Now QV stops during the execution of the Task (with error). Within the application when starting reload the macro runs fine and no error. Problem therefore is somehow in the fact that in the command line opening, reloading and sending mail is somehow to slow or something.

Anybody an idea what causes this problem.

Marc

Problem with command line and macro to mail reports in Windows Tasks

gandelr — Fri, 12 Nov 2010 10:40:23 GMT

Hy,

I had a similar problem and solved it like this:

qv.exe 'filename' -delete parameter /r

create macro:

sub start
ActiveDocument.Reload
ActiveDocument.ClearAll false
ActiveDocument.GetApplication.WaitForIdle

call <function>

ActiveDocument.GetApplication.Quit

end sub

this sub start on event OpenDocument and delete evet on afterreload

topic Problem with command line and macro to mail reports in Windows Tasks in QlikView

Problem with command line and macro to mail reports in Windows Tasks

Problem with command line and macro to mail reports in Windows Tasks