How can I get the file sizes of network drives? Filelen() is not recognizing network names. Thanks for any help.
How can I get the file sizes of network drives? Filelen() is not recognizing network names. Thanks for any help.
Hello schulzy175,
This works on my local network. Give it try on yours.
![]()
Please Login or Register to view this content.
Sincerely,
Leith Ross
Remember To Do the Following....
1. Use code tags. Place [CODE] before the first line of code and [/CODE] after the last line of code.2. Thank those who have helped you by clicking the Starbelow the post.
3. Please mark your post [SOLVED] if it has been answered satisfactorily.
Old Scottish Proverb...
Luathaid gu deanamh maille! (Rushing causes delays!)
Hi schulzy175,
Based on this early binding FileSystemObject example I written the following late binding equivalent:
HTH![]()
Please Login or Register to view this content.
Robert
Last edited by Trebor76; 01-24-2018 at 07:48 PM.
____________________________________________
Please ensure you mark your thread as Solved once it is. Click here to see how
If this post helps, please don't forget to say thanks by clicking the star icon in the bottom left-hand corner of my post
Much thanks for the codes, but I've already had it working locally, but I am trying to replace "C:" with a network name. i.e. "\\MYNETWORK" OR "\\MYNETWORK\FOLDER". My apologies for not being clearer in the first post.![]()
Hello schulzy175,
So you want to convert a mapped drive letter to it is UNC path?
Does this work for you ?
![]()
Please Login or Register to view this content.
Avoid using Select, Selection and Activate in your code. Use With ... End With instead.
You can show your appreciation for those that have helped you by clicking the * at the bottom left of any of their posts.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks