I have a Qlikview Document that tracks files and folders.
I have buttons that can open the file or the Directory.
I am looking for a Macro that can delete a file I have selected
I found this and it works
set oFile = createObject("Scripting.FileSystemObject")
currentStatus = oFile.FileExists(rFile)
if currentStatus = true then
set oFile = Nothing
but I want it to delete a file I have selected from a Straight Table
I reckoned you already knew how to get the values from a field in a macro. Here's a bit from the api guide:
set doc = ActiveDocument
set mySelections = doc.fields("Field").GetSelectedValues
for i = 0 to mySelections.Count - 1
Perhaps activedocument.fields("Full Path").getselectedvalues.item(0).text is enough to get the value you want.
Actually I don't have it working.
Not sure what the issue is.
I have attached the qvw, would reallyappreciate if you could help get it working thanks G
Well, I can't actually delete the file, but if I select the file in the field Full Path first then I can use a msgbox to echo the file name. So that part works.