I am not sure if anyone has come across this issue.
I have a few data tables which the user need to give to create graphs. If I need to create a trend chart, what is the best way to do it? I am trying to remove the user input so it's automatic.
How to make a script automatic to which selects all the data tables(xls or csv) in a each folder of the parent folder and make graphs and save them?
Thank you for your inputs.
As a start point you might want to check out the function Files In DIrectory.