Scripting.FileSystemObject Networking
 

Dear colleagues,
I have a problem to reference the FileSystemObject object through the
simple LAN connection.
For example of this problem let's say that I am working on the
Computer named "comp1" & trying to reference some VBA objects on
another Computer on the network named "comp2". Generaly LAN is working
correctly even when using VBA the :
Statement ChDir "\\comp2\c" works with no problem
Function Dir("\\comp2\c") works with no problem
Copying files through the network(using VBA) from "c\MyDoc" to
"\\comp2\c" works with no problem

So, the actual problem is how to reference the FileSystemObject object
on the "\\comp2" from "\\comp1" (or from any Dir on "comp1" ie just
from "c\MyDoc")
Variables:
Dim fso as Object '(=FileSystemObject)
The statement
Set fso = CreateObject("Scripting.FileSystemObject", "\\comp2")
returns the error: "Run-time error '462' The remote server machine
does not exist or is unavailable"
The statements:
Set fso = CreateObject("Scripting.FileSystemObject")
Set fso = CreateObject("Scripting.FileSystemObject", "\\comp1")
both works & returns the FileSystemObject on "comp1"
Althought I think that there is no problem with network just brief
network info:
- on both PC's ("comp1" & "comp2") there are Win98 & Office 2000
- connection Planet_ENW9504_PCI_networkCards, UTP cable, via Switch,
protocol IPX/SPX
-Services File&PrinterSharing & ClientforMicrosoftNetworks

So far I have trying (unsuccessfuly) to find solution on the following
web sites:
CPearson; ErlandserData; J-Walk; StephenBulXLS; DaveMcRitchie &
offcourse Office2000 VBA-Help

So anyone who knows:
- the solution of this problem, or
- the relevant web site which enlight this theme
please reply.
Thank You in advance.