Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
FileSystem.RMDIR | Excel Programming | |||
Filesystem again | Excel Programming | |||
To Bob Phillips ( Filesystem) | Excel Programming | |||
Filesystem again | Excel Programming | |||
Copying files ...Network to Network | Excel Programming |