Often when dealing with excel you will create a new directory on the server and copy in relevant files; then use qlikview to compile the result.
In order to do this you have a screen of variables you can change.
At some point this gets very long and Qlikview is not very good at this when using input boxes to store long names or make new directories using VBscript because you dont have cells like excel,
What do people do when you get into alot of variable?
Do you create an excel pop up sheet to do the complex work like directory tress and copying files into it?
