topic running DOS command in Macro in QlikView

running DOS command in Macro

khag_hs — Fri, 23 Jun 2017 08:28:47 GMT

Hallo,

how can I run a DOS command in a Macro?

for exampel:

copy *.txt test_new.txt /b /y

m_woolf — Fri, 23 Jun 2017 11:55:31 GMT

Set oShell = WScript.CreateObject("WSCript.shell") oShell.run "copy *.txt test_new.txt /b /y"

khag_hs — Tue, 04 Jul 2017 12:32:35 GMT

Sorry, it doesn’t work.

But if I create a BAT-file which contains the command (copy *txt test_new.txt /b/y) and starts the BAT-file with the macro it works:

Set oShell =
CreateObject("WScript.Shell")

oShell.Run "make_a_copy.bat"

Content of the BAT-File “make_a_copy.bat”:

start/MIN

copy *.txt test_new.txt /b /y

exit

So, thank You for Your help, even if it’s not the direct solution.