I have a requirement where i have to attach more than 20 excel files in my dashboard. I tried a solution, i created a folder structure on server. One folder for every team then each folder month wise sub folders as i will receive these files on monthly basis.
In my dashboard, i created 7 buttons for each such folder as i want my client to go in main folder and then select any month's folder and access the files in it.
Now the problem is it works on my local machine and as soon as i deploy it on server, it does not work.
can anyone help out here..? Or any suggestion how it can be done some other way..??
What if you used variables instead and put the paths in each variable, and you could use the wildcard piece from the link below as well I think, just an idea, might be simpler, so the variable would go into your From statement etc. If I have misunderstood what you are doing, sorry, but hopefully this may give you some further ideas.
To help users find verified answers, please do not forget to use the "Accept as Solution" button on any post(s) that helped you resolve your problem or question. I now work a compressed schedule, Tuesday, Wednesday and Thursday, so those will be the days I will reply to any follow-up posts.