Discussion Board for collaboration on QlikView Scripting.
I have a macro that I want to run for every file in a particular folder.
i.e. At the moment I have
Sub Macro ()
I want something along the lines of:
Set folder = 'C:\TEMP\'
For each file in folder
What's the correct code I should be putting in to get it doing the rest of my code for each file in the folder?
Not sure if you're still working on this but I found Michael Anthony's solution on the below thread to be very helpful.
search for filenames in a directory within a macro
I used this loop to convert XML to Excel XLS format for all files in a folder, I trust you'll also find this to be very useful.