+ Reply to Thread
Results 1 to 1 of 1

Load data from excel using another user profile SQL

  1. #1
    Registered User
    Join Date
    07-22-2011
    Location
    Cardiff, Wales
    MS-Off Ver
    Excel 2007
    Posts
    1

    Load data from excel using another user profile SQL

    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
    Please Login or Register  to view this content.
    Last edited by Leith Ross; 07-22-2011 at 12:00 PM. Reason: Added Code Tags

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1