topic Macro to call a program in QlikView

Macro to call a program

johnan — Fri, 08 May 2009 15:53:53 GMT

Hi,
I have a button to call a program in QV. Can I load button so that after the script is loaded to automatically make a button press? Or a macro for this?

Macro to call a program

manishkumar75 — Fri, 08 May 2009 16:08:55 GMT

Hi Johnan,

As per my understanding (I may be wrong) , you want a macro to be run on the opening of QlikView document. If it is so, you can assign that macro to Document Event Triggers - > On Open , using Document properties and selecting Macros tab.

- Manish

Macro to call a program

johnan — Fri, 08 May 2009 16:13:13 GMT

Yes, thats correct. But, when you create a button, you can call a program. I have a "batfile" that i want to execute after reloading the document.

If i can call that batfile in macro and then execute after reloading the script, i't would be nice.

Sorry for my bad english

Macro to call a program

Fri, 08 May 2009 16:31:29 GMT

Hello Johnan,

You can perhaps use a macro like this:


Sub LaunchBatch
 set app=ActiveDocument.GetApplication
 app.Launch "c:\test.bat",""
End Sub

regards Mark

Macro to call a program

johnan — Fri, 08 May 2009 16:41:24 GMT

Hi, i tried but:

Expected end of statement

in macro

Macro to call a program

Fri, 08 May 2009 16:58:40 GMT

Try this:

doc = ActiveDocument
b = doc.GetSheetObject("BU99")
b.Press

Regards,

Gordon

Macro to call a program

Fri, 08 May 2009 17:05:40 GMT


johnan wrote:
Hi, i tried but:

Expected end of statement
in macro

It works over here, what version of QlikView do you use? Did you point to an existing bat file?

Macro to call a program

johnan — Fri, 08 May 2009 18:07:19 GMT

8.50

Macro to call a program

johnan — Fri, 08 May 2009 18:30:40 GMT

Hi,

got this error:

Object required: 'doc'

Macro to call a program

Fri, 08 May 2009 18:38:34 GMT

Copy/paste lost 'set'.

Set doc = ActiveDocument
Set b = doc.GetSheetObject("BU99")
b.Press

Macro to call a program

johnan — Fri, 08 May 2009 18:41:55 GMT

Aha 🙂

But:

sub pressa
Set doc = ActiveDocument
b = doc.GetSheetObject("BU05")
b.Press
end sub

Object doesn't support this property or method: 'b'

Using QV 8.50

Macro to call a program

johnan — Fri, 08 May 2009 18:46:23 GMT

Sorry, it works:

sub pressa
Set doc = ActiveDocument
Set b = doc.GetSheetObject("BU05")
b.Press
end sub

Macro to call a program

johnan — Fri, 08 May 2009 18:51:38 GMT

next question, can i hide the button

Macro to call a program

Fri, 08 May 2009 18:57:14 GMT

Properties>Layout>Show..Condtional (1<>1)

Macro to call a program

johnan — Fri, 08 May 2009 19:03:55 GMT

Thanx, works good!

Macro to call a program

yblake — Sat, 09 May 2009 02:29:07 GMT

I don't use macro to launch exe or bat after reload, i do it directly in script using execute (you have to allow external program execution in the script options on last tab):

set TMPDIR = 'C:\Users\my_user\AppData\Local\Temp';

// execute a console application (this one extract RAR archive content to temporary folder)
execute extract.exe /rar="my_archive.rar" /output="$(TMPDIR)";

csv_list:
first 1 LOAD
filename() as File,
filetime() as Time,
filesize() as Size
FROM $(TMPDIR)\*.csv (ansi, txt, delimiter is ';', embedded labels, no quotes);

// execute DOS shell command (this one delete temporary extracted files)
execute cmd /d /q /v:off /c "del /f /q $(TMPDIR)\*.csv";

Macro to call a program

Mon, 19 Sep 2011 11:01:15 GMT

Hi All,

i tried this one its working But its not Stoping.... Can any one tell me how to stop this once excecuted?