I have been working on providing data analysis for a report that has been generated out of SAP. Since it required maximum automation, I wrote macro to get that excel report from a particular folder and then perform all actions on it.

However, now this analysis spreadsheet I created is going to become a template so that anyone can run the report and have results in front of them. In the macro, I wrote, it fetches the file from my hard drive. What is the way to go when it has to be in a common location?. How can this be achieved?

I have heard of a shared drive but I have no idea behind the concept.

Plz help.