In a macro I traverse a file path and collect some data which to be stored into several variables.
Now I use public variables to use them further in the macro and manipulate values under a change event by having multiple variables like 'Value', 'ValueRead' and 'ValueWrite'.
I think I learnt this is not an effective way to treat values.
What you've think is the best way to keep the original found value to have the ability to compare with and otherwise create a value used to create the new or changed filename ?
Is it better doing this with a Sub or a Function or is there a much better technique ?