Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in Toronto Sept 9th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
johnan
Creator III
Creator III

Macro to call a program

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?

16 Replies
johnan
Creator III
Creator III
Author

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

johnan
Creator III
Creator III
Author

Sorry, it works:

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

johnan
Creator III
Creator III
Author

next question, can i hide the buttonTongue Tied

Not applicable

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

johnan
Creator III
Creator III
Author

Thanx, works good!

yblake
Partner - Creator II
Partner - Creator II

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";

Not applicable

Hi All,

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