ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Scripting.FileSystem Network Unavailable (https://www.excelbanter.com/excel-programming/349850-scripting-filesystem-network-unavailable.html)

[email protected]

Scripting.FileSystem Network Unavailable
 
Dear colleagues,
I am trying to access network drives with VBA_Excel _
Scripting.FileSystemObject, but so far unsuccesfully.
I have install the SCRRUN.DLL (also SCROBJ.DLL) and include the
reference to this dll in VBProject('Microsoft Scripting Runtime'), but
still can't acces to shared network drives. When create the 'FSO'
object - Scripting.FileSystemObject in his 'Drives'_Collection there
are only 'local drives' listed. Also via WScript.Network =
EnumNetworkDrives, I get empty collection i.e. 'lenght' property = 0.
Do I miss some additional reference(-s) ???
So, if somebody know the solution, please, help.
Thank You in advance.
Mirom.


Tim Williams

Scripting.FileSystem Network Unavailable
 
Can you show some code? Are you trying to access a mapped drive?

Tim


wrote in message
oups.com...
Dear colleagues,
I am trying to access network drives with VBA_Excel _
Scripting.FileSystemObject, but so far unsuccesfully.
I have install the SCRRUN.DLL (also SCROBJ.DLL) and include the
reference to this dll in VBProject('Microsoft Scripting Runtime'), but
still can't acces to shared network drives. When create the 'FSO'
object - Scripting.FileSystemObject in his 'Drives'_Collection there
are only 'local drives' listed. Also via WScript.Network =
EnumNetworkDrives, I get empty collection i.e. 'lenght' property = 0.
Do I miss some additional reference(-s) ???
So, if somebody know the solution, please, help.
Thank You in advance.
Mirom.





All times are GMT +1. The time now is 05:12 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com