Consulting

Results 1 to 3 of 3

Thread: Save to Network drive using UNC format

  1. #1
    VBAX Regular
    Joined
    Apr 2017
    Posts
    66
    Location

    Save to Network drive using UNC format

    I'm trying to save to a network drive using "UNC" (Universal Naming Convention) format vs. the mapped letter drive.

    Saving using the mapped letter drive below works fine:
    HTML Code:
    F:\Folder\SubFolder1\SubFolder2\FileName.xls
    My understanding is that I just need to replace the F: with it's UNC format, but saving using that as below does not work:
    HTML Code:
    \\NetworkDrive\F:NetworkFolder\SubFolder1\SubFolder2\FileName.xls
    I get Error 1004 - Cannot access drive ... File name or path does not exit...

    Any suggestions to fix?

  2. #2
    VBAX Guru Kenneth Hobs's Avatar
    Joined
    Nov 2005
    Location
    Tecumseh, OK
    Posts
    4,956
    Location
    Your network path does not exist. You can test by WIN+E and paste:
    \\NetworkDrive\F:NetworkFolder\SubFolder1\SubFolder2
    or even
    \\NetworkDrive\F:NetworkFolder
    maybe?
    \\NetworkDrive\NetworkFolder\SubFolder1\SubFolder2

  3. #3
    VBAX Regular
    Joined
    Apr 2017
    Posts
    66
    Location
    Thank you! The test you suggested was the key. The shared drive had a prefix that was apparently another folder that needed to be included in the full path.

Posting Permissions

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