+ Reply to Thread
Results 1 to 1 of 1

Scripting.FileSystemObject GetFolder not working on Network Drive

  1. #1
    Registered User
    Join Date
    10-03-2012
    Location
    Monroe, GA
    MS-Off Ver
    Excel 2010
    Posts
    1

    Scripting.FileSystemObject GetFolder not working on Network Drive

    I am creating a userform that will prompt for the .xls filename to be used in another macro.
    The code below works on my local drive.
    If I want it to go out to the company's network, it says path not found.
    However, if I go into Excel and go File / Open, and cut and paste the same network path, the path is found and files displayed.
    Since Excel itself will recognize the path,it doesn't seem like it should be a permissions problem.

    Calling code:
    Works:
    Call ListFilestoListBox("C:\Users\xxxx\Documents\Company\Excel/", False)
    Does Not work:
    Call ListFilestoListBox("http://xshare.xxx.com/Groups/Operations/XXXInfrastructure/Weekly Data/", False)

    Subroutine in Userform

    Please Login or Register  to view this content.
    Last edited by Leith Ross; 05-12-2014 at 07:31 PM. Reason: Added Code Tags

  2. #2
    Registered User
    Join Date
    10-03-2012
    Location
    Monroe, GA
    MS-Off Ver
    Excel 2010
    Posts
    1

    Re: Scripting.FileSystemObject GetFolder not working on Network Drive

    I figured it out... if I take out the "http:" and just use ""//xshare.xxx.com/Groups/Operations/XXXInfrastructure/Weekly Data/"" it works.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Trying to search for list of strings using Arrays,Scripting Dictionary or FileSystemObject
    By downtown1933 in forum Excel Programming / VBA / Macros
    Replies: 42
    Last Post: 10-01-2013, 04:38 AM
  2. [SOLVED] GetFolder Method of FileSystemObject Fails On Second Pass
    By goss in forum Excel General
    Replies: 4
    Last Post: 11-14-2012, 01:27 PM
  3. [SOLVED] Windows XP : Network drive mapping not working
    By Sammitry in forum Microsoft Windows Help
    Replies: 3
    Last Post: 07-23-2012, 05:32 AM
  4. Scripting.FileSystemObject gives Permission denied
    By CrazyFileMaker in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 03-16-2011, 02:29 PM
  5. [SOLVED] Scripting.FileSystemObject
    By Leif Rasmussen in forum Excel General
    Replies: 1
    Last Post: 01-12-2005, 08:06 PM

Tags for this Thread

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