Closed Thread
Results 1 to 5 of 5

Vba that can give user name and password given with in vba to access a network locatn

  1. #1
    Forum Contributor
    Join Date
    03-11-2013
    Location
    india
    MS-Off Ver
    Excel 2007
    Posts
    736

    Vba that can give user name and password given with in vba to access a network locatn

    Please Login or Register  to view this content.
    This code i am using to open a file kept at network location by giving the filetpath in cell a1

    But the problem is that network path is protected by a user name and password
    So everytime before using this code i will have to manually access that node by putting user id and password then i can use that code...

    Can i give user name and password with in this vba to avoid putting password again and again manually

    Plz assist
    Last edited by ROHAN999; 09-27-2018 at 12:19 AM.

  2. #2
    Forum Expert BadlySpelledBuoy's Avatar
    Join Date
    06-14-2013
    Location
    East Sussex, UK
    MS-Off Ver
    365
    Posts
    7,944

    Re: Vba that can give user name and password given with in vba to access a network locatn

    Your post does not comply with Rule 2 of our Forum RULES. Use code tags around code.

    Posting code between [CODE]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/CODE] tags makes your code much easier to read and copy for testing, it also maintains VBA formatting.

    Click on Edit to open your thread, then highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found here

    (This thread should receive no further responses until this moderation request is fulfilled, as per Forum Rule 6)

    BSB

  3. #3
    Forum Contributor
    Join Date
    03-11-2013
    Location
    india
    MS-Off Ver
    Excel 2007
    Posts
    736

    Re: Vba that can give user name and password given with in vba to access a network locatn

    Modified thanx

    Kindly assist

  4. #4
    Forum Contributor
    Join Date
    03-11-2013
    Location
    india
    MS-Off Ver
    Excel 2007
    Posts
    736

    Re: Vba that can give user name and password given with in vba to access a network locatn

    Any expert plz

  5. #5
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    53,048

    Re: Vba that can give user name and password given with in vba to access a network locatn

    Your post does not comply with Rule 7 of our Forum RULES.

    Don't post questions regarding breaking or bypassing any security measure. Such posts will be deleted, and repeat offenders will be banned. This includes posting of links to sites that offer software, code or services to do this or posting of code to remove passwords

    Thread Closed
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford

Closed Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Multiple User AddIn Access (Installer/RegEntry/Network Drive)
    By DH123 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 07-22-2016, 11:14 AM
  2. [SOLVED] User Name and Password - if blank need to deny access
    By silentcarl in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-30-2016, 09:09 AM
  3. Replies: 2
    Last Post: 08-09-2014, 06:15 PM
  4. Open spreadsheet using network password
    By JamesT1 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 05-01-2014, 09:42 AM
  5. write on an excel file over the network that user only has read-only access to
    By vangxbg in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 05-09-2013, 08:41 AM
  6. network user access
    By khalid79m in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 10-04-2007, 12:58 PM
  7. [SOLVED] ADO / Excel & Access: User ID and Password
    By Santiago in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 08-05-2005, 05:05 PM

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