+ Reply to Thread
Results 1 to 3 of 3

Check permissions to a shared drive

  1. #1
    Registered User
    Join Date
    03-05-2013
    Location
    Leeds
    MS-Off Ver
    Excel 2003
    Posts
    2

    Check permissions to a shared drive

    I have code which is basically using ChDir to check if i can change the directory to a variable (which is a list of areas provided to me). The odd thing is some of the results are coming back as Yes when i dont have access to the network drive, ie

    ChDir "shareddrive\folder_1"

    Is coming back as Error = 0 even though i cant get into folder 1. However i can reach Shareddrive

    Essentially what im trying to obtain is what drives i can see, and what drives i can write to

    Any suggestions?

  2. #2
    Forum Expert Alf's Avatar
    Join Date
    03-13-2004
    Location
    Gothenburg/Mullsjoe, Sweden
    MS-Off Ver
    Excel 2019 and not sure I like it
    Posts
    4,784

    Re: Check permissions to a shared drive

    and what drives i can write to
    I think you have answered you own question i.e. first use "ChDir" and if no error then try to place a temp file to that directory?

    Alf

  3. #3
    Registered User
    Join Date
    03-05-2013
    Location
    Leeds
    MS-Off Ver
    Excel 2003
    Posts
    2

    Re: Check permissions to a shared drive

    Unfortunaley chdir is returning 0 (no error)

    Yet i cant access the path in windows explorer. Permission denied

+ 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