Macro to call a program

[johnan]

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?

[johnan]

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]

Sorry, it works:

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

[johnan]

next question, can i hide the button

[#5 · Accepted solution]

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

[johnan]

Thanx, works good!

[yblake]

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

[#8]

Hi All,

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