topic DOS-Command in a macro in QlikView

DOS-Command in a macro

bumin — Sun, 29 Dec 2013 17:36:33 GMT

Hi,

has anyone an example how to enter a DOS-Command in a QV-macro?

I want ro rename a file within a macro

thanks

Bumin

Sun, 29 Dec 2013 21:12:09 GMT

Hi Bumin,

The below macro (vbscript) will do the job without the need for a dos command:

sub renamefile

set obj = CreateObject("Scripting.FileSystemObject")

strFile = "C:\Users\Test\Desktop\QVW\s.csv"

strRename = "C:\Users\Test\Desktop\QVW\sRenamed.csv"

if obj.FileExists(strFile) then

obj.MoveFile strFile, strRename

else

msgbox("File Doesn't Exist")

end if

set obj = nothing

end sub

Make sure to set the security flag to "allow system access".

Hope this helps.

qlikpahadi07 — Mon, 30 Dec 2013 05:20:18 GMT

perfect it worked with me

bumin — Mon, 30 Dec 2013 10:57:48 GMT

thanks Jean-Pierre it works

Mon, 30 Dec 2013 11:08:21 GMT

Great

Appreciate to mark the answer as correct/helpful.