use/set variables in execute statement

[yelin_nyu]

I have a execute statement to extract from zip file. but the file name will have a different date each week.

the file location has many batches of data, I need to make sure im picking up the right week's data.

I set the variables in qlikview, tried to use it in the file name in the execute statement, but it's not working.

let vFileName='Hey_';
let vBatch=date(weekstart(today()),'YYYYMMDD');
let vFileExt='.zip';
let vFile=vFileName&vBatch&vFileExt;

execute "\\MyFilePath\7za.exe" e \\\MyFilePath\FTP\$(vFile) -y -o\\MyFilePath\Input\*;

[rubenmarin · Accepted solution]

Hi yelin, I think it should work, maybe is the triple-dash in \\\MyFilePath\FTP or it need to add a space between -o and the path in -o\\MyFilePath\Input\*;

[yelin_nyu]

it's the triple \, im so sorry to waste everyone's time. however you cannot put a space btw -o and the file path, it would not  work. part of the syntax I believe. took me a couple trial and error to figure that out.