Hello
I've written some code in VBA that will load the customer information of a defined sales region from another excel document and load it into the VBA document.
The whole point of this is basically that all the customer information is stored in 1 excel document, but we want the reps working the various regions to have access to their customers info, without being able to see the info for other regions.
The problem I now have is that the code only works if they have access to the master file, which defeats the whole purpose of the second spreadsheet. I've tried tweaking the users permission on the folder itself, but the minimum permissions needed to allow the code to run, allows them access to the master file as well.
My current idea is to create a generic user with permission to the folder, and then have the VBA code read the master document as if it was that profile, but so far I haven't been able to figure anything out, or find a solution online.
Can anyone help me, or offer any other methods?
Thanks
Bookmarks